problem on blank space

please help me...

i have a table namely "list"

where field names are name,age,remark

and table display like $=blank space

name age remark
ajit 22 jksakgfjkahfhhsaklhj
raju 21 $$$$$$$$$$$$$$$$p

now the problem is that i want to remove the whole row where remarks field ended with "p" but i don't know how many $ are there before p.

please help me to solve this

Quote:

Originally Posted by madhurjya

please help me...

i have a table namely "list"

where field names are name,age,remark

and table display like $=blank space

name age remark
ajit 22 jksakgfjkahfhhsaklhj
raju 21 $$$$$$$$$$$$$$$$p

now the problem is that i want to remove the whole row where remarks field ended with "p" but i don't know how many $ are there before p.

please help me to solve this

use right() function to find the row.

delete from list where right(remark,1)='p'.