 |
BorlandTalk.com Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Sydney Lotterby Guest
|
Posted: Sun Apr 16, 2006 2:03 am Post subject: Parsing tool to handle nested booleans |
|
|
I am looking for a D7 and higher VCL that will enable me to parse a
free-form string like we are all used to entering in Google etc. The db to
be searched is SQL 2000 and contains all 'words' in all Text blobs for all
rows of a table. When the user enters something like
SMITH+GEORGE+(MALE|FEMALE) or alternately SMITH and GEORGE and (MALE or
FEMALE)
I need to reduce this to an SQL where statement like:
..... where Word='SMITH' and Word='George' and (Word='MALE' or Word='FEMALE')
Anyone know of a tool to do this? |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|