What is happening here is that: LABEL like "%Chr$(13)%" is looking for the literal value of "Chr$(13)"
The function Chr$(13) is never executed so it does not return the value of carriage return (line feed or any other special char) Try this method ie LABEL like "%" + Chr$(13) + "%" or try using instr instead ie InStr(1,LABEL,Chr$(13)) - Steve Chan On 1/16/06, David Reid <[EMAIL PROTECTED]> wrote: > Greetings Everyone, > > I have a label table in which some labels with multiple words have carriage > returns or line feeds between words. > > I have updated the background data with the text of the label > _Objectinfo(obj,3)_ > > I wish to select only the records which have line feeds or carriage returns > (any record with at least one return) so I can clean those characters out so > I can create a clean index table. > > I see that if I copy the text of the label from the browser and paste it as > text in UltraEdit and switch to hexadecimal mode, the characters for the > returns are 0A which translate to decimal code "10" chr$(10) or a line feed. > > > I've tried with no success the following: > > Select: * > From: MYTABLE > Where: LABEL like "%chr$(10)%" (line feed) > > Where: LABEL like "%chr$(13)%" (carriage return) > > Where: LABEL like "%chr$(28)%" 29 & 30 (file, group, record separator) > > Where: LABEL like "%\n%" > > > I just new one of these would work but no such luck. What am I missing here? > > > Thanks, > David Reid > > -- > Outgoing mail is certified Virus Free > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date: 01/14/2006 > > > > _______________________________________________ > MapInfo-L mailing list > MapInfo-L@lists.directionsmag.com > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l