Forum Replies Created

Viewing 2 posts - 1,471 through 1,472 (of 1,472 total)

  • RE: Splitting a String in SQL - Help Please!

    If the -'s are there in every string, you can use CHARINDEX to extract the middle piece.

    DECLARE @String varchar(60)

    SET @String = 'CSCAR009/0001/001-PASPBD-Pedestrian automatic sliding door'

    SELECT LEFT(RIGHT(@String,LEN(@String)-18),(CHARINDEX('-',RIGHT(@String,LEN(@String)-18) ) )-1)

    The best thing...

    September 12, 2008 at 1:09 pm

    #871292

  • RE: To Retrieve the records by Negating the First condition

    If I'm reading this correctly, you'd want to do something like this:

    UPDATE table_A

    SET C_Flag = 'W'

    FROM table_A A

    INNER JOIN table_B B ON A.X_CODE = B.Y_CODE

    LEFT JOIN...

    September 12, 2008 at 12:53 pm

    #871275

Viewing 2 posts - 1,471 through 1,472 (of 1,472 total)