Results 1 to 15 of 17

Thread: Truncate characters in a column

Hybrid View

  1. 01-27-2006, 12:29 PM #1
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    select convert(char(5), '034353101')
    Reply With Quote Reply With Quote
  2. 01-27-2006, 01:00 PM #2
    Iggy_Pop
    Iggy_Pop is offline Registered User
    Join Date
    Aug 2005
    Posts
    31
    Is there a means of specifying a column to convert like that?
    I have about 1000 zip codes that are too long. Thanks for your help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules