Insert using SQL

Results 1 to 2 of 2

Thread: Insert using SQL

  1. #1
    Join Date
    Dec 1969

    Default Insert using SQL

    Can I insert into a string at postion 6 a zero where it will move everything to the right but no write over the data in the field already.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default huh??

    you want to change but not overwrite the data??<BR><BR>as in another column??<BR><BR><BR>anoywho<BR><BR>you will need somethign like this<BR><BR>replace(ColumnName, left(ColumnName, 5), left(ColumnName, 5)+&#039;0&#039;)<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts