as title, I would to know how replace only the first char of a record if it contains a determinate char?
record: " hello" --> record "hello".
If YourField has a space as first character, use this. You can, ofcourse, change the first character to whatever you like.
UPDATE YourTable SET YourField = RIGHT(YourField,LENGTH(YourField)-1) WHERE YourField like ' %'