Post reply

Column split

  • December 21, 2010 at 8:36 am

    #148022

    I have a column with values like "Solo >5 months $10 Target". I want to split the column into two columns starting from $. Please help me. Thank you.

    Note: I have some without $ which i don't want to split and leave a null value.

  • December 21, 2010 at 8:47 am

    #1265123

    Look up charindex, left and substring in books online.

  • December 21, 2010 at 11:04 am

    #1265204

    Thank you.

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

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