Viewing 5 posts - 1 through 5 (of 5 total)
It looks fine in PilotEdit as well as in Notepad++
December 17, 2020 at 11:55 am
June 21, 2017 at 5:10 am
I found it very simple way as below.
SELECT CompanyAddress AS OriginalString,
SUBSTRING(CompanyAddress, 1, PATINDEX('%[0-9][a-z]%', CompanyAddress)) AS FirstPart,
...
May 19, 2016 at 1:33 am
Viewing 5 posts - 1 through 5 (of 5 total)