469,578 Members | 1,700 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

Searching and matching string field

I have a 'Names' field in a table which has names with initials like 'T S Rxxx', 'T.S.Rxxxx', 'TS Rxxx'.
But if the user types 'T S R' or 'T.S.R' in search box, the result should show all these names.
In another words, how to replace fullstops & spaces in names field and compare them with the search word which I can cleanup using ASP's Replace property?
Basic Query:
"select names from table where names like '%cleanedupstring%' "
Is there any way I can use find & replace here for dots & spaces?

I can not compare each & every name as my table has more than 5000 rows.
Aug 20 '07 #1
0 886

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Michael | last post: by
8 posts views Thread by Gordon Knote | last post: by
10 posts views Thread by C Downey | last post: by
33 posts views Thread by Geoff Jones | last post: by
1 post views Thread by Joe Strout | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.