Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Counting the characters in a string before a space RE: Counting the characters in a string before a space

  • June 12, 2014 at 9:03 am

    #1721107

    cbrammer1219 (6/12/2014)

    This doesn't work for what I am wanting, it is counting the spaces, It doesn't count the characters before the spaces, as you see in the data below for 5...It should be 3 for the first set of 5's and 2 for the 2nd set of 5's. I am not sure what this is doing with the numbers, instead of a comma I changed to (' ') a space.

    5555 55 1NULL

    5555 55 2NULL

    65 5555 hhh1NULL

    65 5555 hhh2NULL

    65 5555 hhh3NULL

    85555 5 lll 1NULL

    85555 5 lll 2NULL

    85555 5 lll 3NULL

    955555 1 k1NULL

    955555 1 k2NULL

    955555 1 k3NULL

    101888 555 jjj551NULL

    101888 555 jjj552NULL

    101888 555 jjj553NULL

    Could you post the code that you used along with some sample data in a consumable format (DDL and insert statements)?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2