how to write quare for fiend the last word

Question

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

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

Florian Reischl SSC-Dedicated Points: 37299 More actions · Answer 1

Hi

Answer to your question:

;WITH t (id, addr) AS

(

SELECT 1, '1_94 SO MATTA REDDY RAJIV CHOWK SAGAR ROAD MIRYALAGUDA'

UNION SELECT 2, '1_187 KERALA ROAD CHILUKUR'

UNION SELECT 3, 'Y KRISHNA REDDY ADVOCATE'

UNION SELECT 4, 'ADVOCATE VIJAY GARDEN BACKSID'

UNION SELECT 5, 'CH CHANDRAIAH ADVOCATE 6_2_15A'

UNION SELECT 6, 'NEAR 6_7_49 RAVINDRA NAGAR NALGONDA'

)

SELECT *, RIGHT(addr, CHARINDEX(' ', REVERSE(addr)) - 1)

FROM t

FOR FUTURE

Please have a look to the following link:

... well posted information will help you to get more, faster and even better response! 😉

Greets

Flo