Optional Wildcard character

[xsnrg]

I am attempting to automated a document search in my database using wildcard options.

I have a field on a form that asks what to search for...
A user can for example type 'CO##_' and they will get all documents that have the letters "CO" followed by a 2 digit number and an "_".
If they type 'c2' it will file anything with "c2" in the name.

However...
I want the ability to find both "c2" and "c-2" in the same search. Is there a wild card I can use that is an optional character
For example a 'c?2' would allow ANY character between the 'c' and the '2', but it will NOT find those with NO character between the 'c' and '2'. How can I get both results in one search?


McLean Jones
buddycenters.org
"Believing is Seeing

 

[Snowcrash]

Hey

SELECT *
FROM Delete_Table
WHERE TableValue LIKE "a?a"

Returns only records that HAVE values that start with a and have a third letter of a.

SELECT *
FROM Delete_Table
WHERE TableValue LIKE "a*a"

Returns records the same records above but also records like "aa" which have no values in between.

Snowcrash