-
Remove the character '
Hello,
I am running a query which will look up names on the field: surname, and then give the first 4 characters of this name... the problem is quite a few names in the database have the character ' in their name!!
Is there a way to only return letters?
Thanks in advance
AJH.
-
Not to worry, i worked it out...
solution: translate(t1.surname,'x,.''";:-','x')
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
|
Click Here to Expand Forum to Full Width
|