-
search substring (same format) from one column
I have one column which contain 6 character(post code), the first, third, fifth is letter and second, forth and sixth is number,how to get them(post code) from each string with sql query, thanks in advance.
for example:
we have address column which contain a long string like this:
1111streetuniversityapp3h1p2w3montrealquebeccanada
we need take h1p2w3 out, which is post code.
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
|
|