I NEED SQL SELECT QUERY TO REPLACE "TIE ROD:¿x180mm" TO TIE ROD:x180mm.

MY CODE SNIPPET FOR REPLACING IS

SELECT REPALCE(FIELDNAME,'¿',' ' ) FROM TABLE NAME ;

BUT IT DOSNT WORKS FOR ME.

PLEASE ANY ONE HELP ME....

THANKS IN ADVANCE

Hi, I think you can try update statement,something like this

Update Yourtable

Set FIELDNAME = replace(FIELDNAME, '¿',' ')

Good luck

Gavin

Hi, I think you can try update statement,something like this

Update Yourtable

Set FIELDNAME = replace(FIELDNAME, '¿',' ')

Good luck

Gavin

Thank a lot for your suggestion Gavin Jin..Your query is fine. What i need is i dont want to update the table but i want to replace them only for viewing using select query..