SQLTeam.com | Weblogs | Forums

How to remove some parts from a long string

I would like to take this row. I have 2 rows per each record. I want to look at this row
I would like to add 10 spaces to this string from the left side.
3324617 873 Broadway New York NY 100031231 (917) 534-1351 (917) 534-0547

Partition by something ..row number

Lead Lag
Join row = row +1. . . I mean row number

look at the CONCAT function