i have database country list, have column in country table named 'isd_code' want append + symbol before each isd code through sql. there query or shortcut because tried excel has + symbol appended when import in sqlite removes + symbol. please me.
to retrieve data symbol prepended:
select '+' || isd_code country to permanently update table:
update country set isd_code = '+' || isd_code
Comments
Post a Comment