Filter out Numbers starting with '04'

[pcfriendly]

Hi Forum,

I have a table of data that contains a Column of telephone numbers.

I want to filter out any records where the telephone number field has a number beginning with '04'.

So far I've added an Advanced Expression something like the below in SAS EG 4.3.

SUBSTR(TELEPHONE_NO, 1, 2) <> '04'

This doesn't work & changes all telephone nunmbers to a single digit, 0, 1 2 etc.

I'd prefer to add afilter in a Query Builder but there isn't an option to write the above expression...

Can anyone advise how this can be done?

Thanks 

[Patrick · Accepted solution]

Not sure about EG 4.3 but in newer versions in the Query Builder you could select as filter operator "Does not match pattern" and as value '04%'

This will translate into SQL:  TELEPHONE_NO NOT LIKE '04%'

[pcfriendly]

Thanks Patrick !

I had tried that using just '04' but didn't think to include the %, DUH ...