Hi Johan, script worked well, but how can i remove last comma (,), ideally i dont want last one showing

its just how it was designed, but this is not a problem, that string in Postcode column will not be bigger than 4 characters, i just need script to update,...

Postcode is 50, but actual string never will be more that 4 digits/letters

LL12,LL13,LL14,LL15,LL16 has only 25 characters, column can hold up to 100, even if it was short, i could increase it, i just need to know how to update that column...

Hi Johan,

How do i get #tmp T1 and #tmp T2? and also once i got string, how do i update that PostcodeNext field for all rows?

My table looks like this

CREATE...

• This reply was modified 3 years, 1 month ago by  pahulyi.

Thanks for your reply,

any chance to write query for me as I am only beginner with SQl querying. I am only learning and not familiar with how to work...