Sorry about the auto-complete of my mobile (even worse within the wrong language)
Here a readable version of the proposed SELECT statement:
SELECT *
From YourTable
Where YourText Like '%!%%' Escape '!'
Another way for selecting Textes that include at least a single % sign would be to use either the scalar function POSSTR or LOCATE
SELECT *
From YourTable
Where PosStr(YourText, '%') > 0
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)
-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Hauser
Gesendet: Tuesday, 15.11 2016 17:57
An: Midrange Systems Technical Discussion
Betreff: AW: Looking for %
The followIng SQLSTATEMENT returns all textra that including a perlen sign.Try:Select *From yourTableWhere yourText likes '%!%%' escape '!'
Birgitta
Von meinem Samsung Gerät gesendet.
-------- Ursprüngliche Nachricht --------
Von: Alan Shore <ashore@xxxxxxxx>
Datum: 15.11.16 15:23 (GMT+01:00)
An: midrange-l@xxxxxxxxxxxx
Betreff: Looking for %
Hi everyone
Before I forget - we are at V7r1 (hooray) When I have to locate records that contain a string in a certain field, I use Select * from filename where field like'%abcde%'
But what do you use if you are looking for the character %
I tried google search it, but google search doesn't like %
As always, any and all responses welcome
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
midrange.com
