Post reply

sql query

  • December 29, 2011 at 1:58 am

    #254117

    I have got a column with data like 12345 0047225P1

    I need a query to select 0047225 as serial number and select P as account letter.

    Thanks

  • December 29, 2011 at 2:14 am

    #1426355

    If it is fixed pattern it should work for you.

    DECLARE @STR VARCHAR(100)

    SET @STR = '12345 0047225P1'

    SELECT SUBSTRING(@Str,CHARINDEX(' ',@Str)+1,7) AS ID,

    SUBSTRING(@Str,CHARINDEX(' ',@Str)+8,1) AS 'Account No'

    Shatrughna

  • December 29, 2011 at 2:16 am

    This was removed by the editor as SPAM

  • December 29, 2011 at 2:28 am

    #1426357

    cheers mate!

  • December 29, 2011 at 2:31 am

    #1426359

    I will test and let you know ... Thanks

  • December 30, 2011 at 3:28 am

    #1426831

    Hello Good Morning...Some of the data is like

    00011 0055500ABC

    So in this Account Number should be 0055500 and Account Letter should be only C

  • December 30, 2011 at 3:42 am

    #1426839

    so basically i need a query to fetch serial number and letter from the column which has two type of data

    12345 0047225P1

    00011 0055500ABC

    The first data should have serial number = 004722 and letter = P

    The second data should have serial number = 0055500AB and letter = C

  • December 30, 2011 at 5:06 am

    #1426887

    Duplicate post.

    Replies here please:

    http://www.sqlservercentral.com/Forums/FindPost1228255.aspx

    -- Gianluca Sartori

  • December 30, 2011 at 5:10 am

    #1426890

    It's not really a duplicate post...

    In this post the account number for "00011 0055500ABC" should be 0055500 whereas in the post Gianluca referenced the expected result is 0055500AB...

    @mario:

    I strongly recommend you first define the expected output instead of asking for different results on different threads related to the very same topic.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 30, 2011 at 5:15 am

    #1426894

    I'm officially confused. :ermm:

    Time for a break.

    -- Gianluca Sartori

Viewing 10 posts - 1 through 9 (of 9 total)

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