Hello every one,

i have table named "item" with a column "item_name".
they are item_name starting wiht the char '#'.
i would like to update all those item_name where the item_name are not
starting whith '#' in this manner :

if the item_name= 'abvc' , i want it to be '$abc'

How can i realise it?

resolved))
here is the solution
update item set item_sc='$'+item_sc where ...