numeric fields 1

[DBrack]

Hello,

I have to select only values that are numeric and length 7 from a table. Such as 1234567, 9092333 etc.. Values such as a190802, aaaaaaa, 10/2233 etc should not be selected. Any help? Thanks

 

[LKBrwnDBA]

Try:

Select * From MyTable
  Where LENGTH(Ncol) = 5
    And TRANSLATE(Ncol,'~0123456789','~') Is NULL;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

OOps, type length()=7!


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb