suppose this is my table
id name address
1 nazir57 gnt
2 suresh hyd
3 sasi priya tpt
4 sankar15 vzg
i want result like the following
id name address
2 suresh hyd
3 sasi priya tpt
how to write the querry for the result. how to write the where condition
please help me
Loading
Biswa Pujarini MohapatraPosted Feb 4, 2014, 4:09 AM
Select * from table where name not like '%[0-9]%'
Suresh BabuPosted Feb 4, 2014, 6:40 AM
[email protected]
send me rply as early as possible
Biswa Pujarini MohapatraPosted Feb 4, 2014, 5:50 AM
please mark it as answer
Suresh BabuPosted Feb 4, 2014, 5:10 AM
Suresh BabuPosted Feb 4, 2014, 5:03 AM
Suresh BabuPosted Feb 4, 2014, 3:29 AM
i want to get the data dynamically am not mention any names or like operators
suppose am having a table with 100 records in which 20 are name with numeric (suresh57) and remaining are normal text.. i want to retrive only text names only not with name with numeric names
r u understand my question now
thanku
pls give me reply
Biswa Pujarini MohapatraPosted Feb 4, 2014, 3:10 AM
Select * from table where name ='suresh' and name ='sasi priya'
or do you want the result name start with S ?