String Search Problem

String Search Problem

Post by Alfre » Thu, 15 Mar 2007 14:04:44


Dear All,

do VFP have command to do that??

a table contains
BVAP
BCAP
NNAP
CDAP
..AP

but can't using $ command
any other ways can find string of '**AP' ???

Thx
 
 
 

String Search Problem

Post by Jay » Thu, 15 Mar 2007 14:39:36

like() should be able to do it

 
 
 

String Search Problem

Post by Anders Alt » Thu, 15 Mar 2007 22:34:47

SELECT * FROM Tablename WHERE column LIKE '%AP'

-Anders
 
 
 

String Search Problem

Post by Dave Tiffa » Fri, 16 Mar 2007 08:50:02

Alfred,

If you want to find the string in a particular position, like the third
and fourth position, try substr(). If the string can appear anywhere in
the field, try occurs().

Dave Tiffany