>I would like to do a where on a text field and check if the values have
>non-numeric characters,
>which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a
>space
>character.
>Is this possible without using a UDF or a very long OR construction?
select * from mytable where mycol
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
RB Smissaert wrote:
> I would like to do a where on a text field and check if the values have
> non-numeric characters,
> which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a space
> character.
> Is this possible without using a UDF
I would like to do a where on a text field and check if the values have
non-numeric characters,
which is in this case is anything other than 1,2,3,4,5,6,7,8,9,0 or a space
character.
Is this possible without using a UDF or a very long OR construction?
RBS
3 matches
Mail list logo