You can use VFP SQL syntax - '45'$cname or you can use ANSI SQL syntax - cname like '%45%'. Note that you need the % wild card on both sides of the substring you're looking for.
rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, April 06, 2010 5:52 PM To: [email protected] Subject: Re: SQL Select and $ operator Just to clarify if mytable contains a record with a value of '12345678' in the cname field and i'm looking for '45' the select statement would be select iid, cname from mytable where cname like '&45' it will return the record described above? i.e. any record with '45' in the cname field... strings like '45678', '9456'. Thanks Mike _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd044067af93...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
