rashmi_k28 Posted September 9, 2008 Share Posted September 9, 2008 How to select the rows which doesnot have digits in that. Suppose id is 121.rr, how to seleect which selects the id's only which doesnot have numeric in it. That is, if id is fa with no numeric digits. How to select only id's like fa and not 121.rr Quote Link to comment Share on other sites More sharing options...
teng84 Posted September 9, 2008 Share Posted September 9, 2008 where id like '%[^1234567890]%' try Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.