Re: How to find linefeeds from data

This method is not correct beacuse the string may contain two symbols one of
which has HEX value ending with '0' and another beginning with 'A'.

<ghingres@xxxxxxxxxxx> wrote in message
news:1119598572.019337.22030@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Here's the way I would do it...
>
> SELECT * FROM TABLE
> WHERE HEX(column_name) LIKE '%0A%';
> \p\g
>
> Just substitute with the HEX value of the ASCII character you are
> searching for...%0A = <NL>, %09 = <TAB> etc...
>
> Cheers
>
> Gary
>


.

Relevant Pages

  • Re: PCL images and mvEnterprise
    ... decimal then CHAR to get the Ascii character. ... to print the letter "A" {'A' is hex 41}, ... or by instead sending the equivalent hex pairs string ...
    (comp.databases.pick)
  • Re: 4-byte ieee754 single-precision floating-point number, convert to string in JS
    ... They are the serialization of the 32-bit single-precision floating- ... point number whose value in hex is 0x41a8147b and whose decimal value ... Or a Method of String which takes 8 characters of the existing String ... scripts written by Dr JRStockton: ...
    (comp.lang.javascript)
  • Hex editor display - can this be more pythonic?
    ... I'm building a hex line editor as a first real Python programming exercise. ... I had considered using the .translatemethod of strings, however this would require a larger translation table than my printable string. ... Where printing chars are shown in parenthesis, characters with Python escape sequences will be shown as their escapes in parens., while non-printing chars with no escapes will be shown with nothing in parens. ...
    (comp.lang.python)
  • Re: compilation problem
    ... want this utility to print decimal for hex numbers entered. ... IF the third argument passed is a string specifying a decimal number ... TERMINATE with an EXIT_SUCCESS returncode ...
    (comp.lang.c)
  • Re: Need a sysRPL CRC16 routine.
    ... Thanks for your thoughts on the string> hex and vice versa. ... Sysrpl is not particularly intuitive on this point. ... effort he has put into the Debug4x programming environment. ...
    (comp.sys.hp48)