|
-
Is it better to get table normalized?
-
declare @str varchar(200)
set @str='1111streetuniversityapp3h1p2w3montrealquebec canada'
select reverse(substring(reverse(@str), patindex('%[0-9][a-z][0-9][a-z][0-9][a-z]%',reverse(@str)),6))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote