Board index » delphi » Local SQL problem
N.Andrews
![]() Delphi Developer |
Wed, 18 Jun 1902 08:00:00 GMT
Local SQL problem
I have a couple problems with Borland local SQL:
Firstly: UK postcodes usually start with two letters indicating the area, SELECT * FROM ADDLIST.DBF WHERE ADDLIST.DBF."POSTCODE" LIKE "LS%" ; However, some cities (e.g. Sheffield) have postcodes that start with a SELECT * FROM ADDLIST.DBF WHERE ADDLIST.DBF."POSTCODE" LIKE "S[1-9]%"; to pick these out, but it doesn't work because "S[1-9]%" gets treated as a Secondly: can any helpful soul tell me how to extend this query into MEMO Thanks in advance, Nick Andrews. (Please don't email me because it isn't |