× 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.



EXCELLENT! That did it!

Thanks for your help.



On 6/26/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

Ron - the LIKE needs a percent sign - string it into the hex literal -
x'6C' is the percent symbol.

WHERE MINLOC LIKE X'6C4E6C'

Or try

where posstr(MINLOC, x'224E20') > 0

-------------- Original message --------------
From: "Ron Adams" <rondadams@xxxxxxxxx>

> Really bad grammar. Try again.
>
> From what I can tell, the characters are usually X'224E20'. It almost
> seems like if these are some key-stroke combination that is not
recognized,
> but I'm not sure what they would be.
>
>
>
> On 6/26/06, Ron Adams wrote:
> >
> > I've got a number of instances in a particular table on my system
where
> > we keep getting bad data at the end of the field. From what I can
tell, the
> > characters are usually X'224E20', not sure it almost seems like if
these
> > are some key-stroke combination that is not recognized, but I'm not
sure
> > what they would be. I am trying to build an SQL statement to show all
the
> > occurences, but I can figure out how to specify the select for the
LIKE.
> > Here's my statement:
> >
> > SELECT PLT, ITMID, MAJLOC, MINLOC FROM ccsdta/dcsilm WHERE MINLOC
> > LIKE X'4E'
> >
> --
> 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.
>
--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.