Hallo,
How to update a TEXT or CHAR field in a table as follows:
An quote character should be inserted at the start and end of the string
in the field.
I tried following query to insert a quote character at the start:
UPDATE MyTable SET VarCharField=INSERT(VarCharField,1,0,'\"');
and it worked.But how to do it at at the start _and_ the end?
UPDATE MyTable SET
VarCharField=INSERT(VarCharField,LENGHT(VarCharField),0,'\"'); didn't
work...
Sir, have you tried
VarCharField = Concat(VarCharField, '\"')
?
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
2 messages in com.mysql.lists.mysqlRe: Problem with updating text field
