combination of charactors and numbers

Database
Enthusiast

combination of charactors and numbers

Hi

I need to find values with combination of characters and numbers.

Example : giri456ty

78shgdsh45

5756shghs

sdhds39587

Thanks
Giri
4 REPLIES
Enthusiast

Re: combination of charactors and numbers

Giri,

you can write a query using LIKE ANY operator

for eg:-

Select field from table where
field LIKE ANY ('%0%','%1%','%2%',%3%,......%9%,'0%','1%','2%',.....,'%0','%1','%2',.......'%9);

I think this should work
Enthusiast

Re: combination of charactors and numbers

There are some ways to identify/differentiate characters and numbers.

Check this post

http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=5&messageid=4532#bm4584

Vinay
Enthusiast

Re: combination of charactors and numbers

Thank U
Enthusiast

Re: combination of charactors and numbers

Thank u