Sql wildcards

[alunr]

My brain has gone blank and everywhere I've searched I get a duff result...

What is the numeric wildcard in SQL (eg testing against a "number" field)

Thanks

[pdV6]

I think you're restricted to > < = !=
LIKE and wildcards are for character data

[Don]

Yep wildcards are for character data only...

You'll just have to express the numeric comparison against a list of numbers or a list of ranges....cheesy but it'll work.

[alunr]

I think I might cry...

Thanks anyway!

[anonymous-user]

This might be a bit late, but you could always cast the numeric to a character datatype and then use the wildcard characters available that way.

Darran