Hi,
How to create the routine for this function not to allow the special characters.
Function :
Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',YourField),'',YourField)
What could be the Code to create the routine for this function ??
Thanks,
John
Creating of Routine fr this Function nt to allow Special Chr
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Oct 15, 2007 10:35 pm
- Location: Charlotte
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Why a routine and not a transform ?
You can make it into routine as
You can make it into routine as
Code: Select all
Ans = Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',Arg1),'',Arg1)