Ignore the .

[sstonge]

I am building a search engine to search through some names of cards. Is there a way when I am using the select statement to get it to ignore cretin characters in the database?

for example someone searches for US, in the database I have it as U.S. , can I make the database skip the periods when using the select statement? Is there an ignore type command that would work?

Thanks

[Moonglobe]

first suggestion: use a dropdown box for stuff like that so you can control user input

second suggestion: use your DBMS's regualr expression functions