Scanning for ASCII characters

[Glenn Waters]

Try the INDEX command

INDEX(string to find something in,string you are looking for)

from the manual

INDEX('abcd','bc')
returns a 2  (bc starts in pos 2)

more exactly
 DEFINE GET_THE_RECORD = INDEX('string1','string2')
 SELECT IF GET_THE_RECORD GT 0   <--- MEANS IT FOUND IT ANYWHERE IN string1

hope this helps..

Glenn


At 03:18 PM 7/21/2000 +0200, you wrote:
>Hello fellow list(en)ers,
>
>once I had a small piece of Quiz code that could chose a record if a
>certain field contained a certain string, like  "ABC" in "lnmABCmk". Now
>you may guess: I do not find it back. Someone still got it? Ah, yes and if
>its RTFM, do not flame me please, no manuals here at that time.
>
>THX a lot & kind regards
>Andreas Noack
>BetzDearborn GmbH
>A division of Hercules
>Development Group Europe
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>This list is closed, thus to post to the list, you must be a subscriber.


Glenn Waters
North Carolina State University 
College of Veterinary Medicine 
4700 Hillsborough St., Box 8401 
Raleigh, NC 27695-8401 
Phone: (919) 513-6652
Fax: (919) 513-6452 
Email: Glenn_Waters@ncsu.edu


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.