Viewing post 1 (of 1 total)
Hi
UPDATE <table name>
set <field name> = SUBSTRING('123AF',1,4)+'D'+SUBSTRING('123AF',5,1)
Regards,
Sasikumar.
July 14, 2006 at 6:06 am
#649213