Post reply

How to get the word like......

  • April 12, 2006 at 3:27 am

    #168453

    Hi Guys,

    I declared one variable and assign the values like 'star, moon, sun, galaxy'

    The output should be 'star', 'moon', 'sun', 'galaxy'

    Thanks in Advance

     

    Kindest Regards,

    karthik

  • April 12, 2006 at 4:40 am

    #632048

    I suspect this is not what you want, but it does do what you asked...

    declare @x varchar(30)

    set @x = 'star, moon, sun, galaxy'

    select '''' + replace(@x, ', ', ''', ''') + ''''

     

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

  • April 12, 2006 at 6:14 pm

    #632263

    Are you looking for some sort of split function to split a comma-delimited list?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply