problem on blank space

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • madhurjya
    New Member
    • Nov 2007
    • 14

    #1

    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 jksakgfjkahfhhs aklhj
    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
  • bashaa
    New Member
    • Nov 2007
    • 2

    #2
    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 jksakgfjkahfhhs aklhj
    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'.

    Comment

    Working...