Selecting records with where clause

[dmacuk]

I have a char(10) field which can contain either a mixture of letters/numbers, or numbers only, e.g. 'ABC123' or '0000123'.

Is there a where condition to only select the records which contain all numbers

TIA

David Mcallum

 

[ceco]

there is, but it will not be very speedy query

WHERE code ~ '^[0-9]*$'

 

[dmacuk]

Thanks, that solved the problem

David