is there a way for me to search sql for a number and ignore non alphanumeric charictors? eg a search for 234 would return 234, 2-3-4, 2)34, 2#34 etc?
TIA Travis Harris
select * from table where cell = '2%3%4'
would that not also return 268435764 ? I need it NOT to ignote alphanumeric charictors
I don't believe the current sql standard provides the pattern matching functionality you require. If your BE is postgres 7.1, you can use regular expressions such as:
select from xxx where col1 ~ '.2[0-9]3[0-9]4.*';
The ~ is like "like"; you can use "!~" too.
See: http://www.postgresql.org/idocs/index.php?functions-matching.html
