Results 1 to 4 of 4

Thread: Splitting up one string into three columns

Threaded View

  1. 08-14-2003, 11:23 AM #1
    cpat
    cpat is offline Registered User
    Join Date
    Aug 2003
    Posts
    4

    Splitting up one string into three columns

    I'm trying to split a hyphen-delimited string into three columns in a view. I've been using substring and len to split up the string, but it is getting very complicated (and isn't working in all cases). I've used a SPLIT function in vbscript - does t-sql have anything similar? I've attached a spreadsheet that shows what I am looking for. Maybe someone can guide me in the right direction?

    Thanks.
    Attached Files Attached Files
    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