Nov 23, 2002 #1 perlTest Programmer Nov 16, 2002 14 0 0 US Hi, Currently I have a table called 'software' and for the price column, it has the following: table: software; id | pid | price 910 1054 $475 911 1055 $501 How do I remove that "$" dollar sign? Thank You. -Matt
Hi, Currently I have a table called 'software' and for the price column, it has the following: table: software; id | pid | price 910 1054 $475 911 1055 $501 How do I remove that "$" dollar sign? Thank You. -Matt
Nov 24, 2002 1 #2 piti Technical User Apr 12, 2001 627 0 0 SK UPDATE software SET price = TRIM(LEADING '$' FROM price) Upvote 0 Downvote
Nov 25, 2002 Thread starter #3 perlTest Programmer Nov 16, 2002 14 0 0 US Thank You! Upvote 0 Downvote