×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Good morning all:
I want to use a simple SQL statement that will retrieve all records on
which the field in question has all characters, no numbers. For example:
FIELDA = 'ABCDEF '
If I have FIELDA = 'ABCDEF7 ', I do not want to list it.
I read in the archives that here is no function like %CHECK in SQL or
stuff like that but I was wondering if there is a simple way of doing
this, and probably is.
TIA,
Peter Vidal
MAPICS IT Technical Support Team / SR System Analyst
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com
"He who kneels the most stands best."
D.L. Moody
--------------------------------------------------------------------------------
Attention:
This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.
--------------------------------------------------------------------------------
midrange.com
