Re: SQL find hexadecimal values in a given range

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

David,

Do you really need SQL for this?

Can you not do a CHECK/SCAN/XLATE with a string/array of non-displayable
hex codes (all less than x'40') on your data?  XLATE to x'40' should be
doable.

With regards,
Carel Teijgeler   

*********** REPLY SEPARATOR  ***********

On 26-3-2009 at 15:18 David FOXWELL wrote:

> This will show the first position and all rows containing  the value hex
> 40.
>
> SELECT locate( X'40', myfield, 1), myfield FROM myfile WHERE
> locate( X'40', myfield)>0
>
> How can I find hex values less that 40?
>
> Thanks
>
> -- 
> 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.
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.0.238 / Virus Database: 270.11.29/2024 - Release Date: 03/26/09
> 07:12:00