[thelist] MS SQl help ASAP

[Ian Barber]

thelist-bounces at lists.evolt.org wrote:
>> -----Original Message-----
>> From: Brian Cummiskey
>> Sent: Tuesday, January 04, 2005 4:32 PM
>>
>> a quick select distinct yeilds:
>>
>>
>> NULL
>>
>> "april"
>> (RPQ)PHONEDISC.
> <snip>


Am I missing a reason why you couldn't do something like:

select * from blah
where blah = 1
and PersonalIdentifier like '%[^0-9]%'

that will just get you anything that contains characters other than 0 to 9.
It'll fail on the null though, so you could coalesce to get around that, or
use ansi nulls.

select * from blah
where blah = 1
and Coalesce(PersonalIdentifier, 'NaughtyNull') like '%[^0-9]%'

Ian.