Alan Stott
SSC-Addicted
Points: 466
More actions
September 28, 2001 at 7:38 am
#157997
Hi,
I need to search a text range e.g. 'al' -'com'. It is not suitable to search between 'a%' and 'c%', any ideas.
Alan S.
Andy Warren
SSC Guru
Points: 119902
September 28, 2001 at 10:53 am
#418573
This wont work?
Select * from whatever where field between 'al' and 'com'
Andy
AndyConnect with me on LinkedIn
October 1, 2001 at 3:05 am
#418583
Yes it does, when I tried it I must of read my results wrong.
Sorry for posting such an inane question.
Alan
October 1, 2001 at 4:46 am
#418584
No problem at all! Hated to post the answer, was afraid I was misreading MY results!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply