Search for records with characters in that have ascii values in the
appropriate range (I'm not sure off the top of my head what the acsii
values for 0-9 are). This could be done easily in MapBasic, but I'm
not sure about in MI Pro directly...
[England 2 - Scotland 0, I reckon]
> This message is in MIME format. Since your mail reader does not
> understand this format, some or all of this message may not be
> legible.
>
> ------_=_NextPart_001_01BF2D02.A3CC06D0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Dear list,
>
> Second problem in two days, so here goes.....
>
> I have a character column, although some of the records have numbers
> in them. How do I go about just selecting those records with a
> number in the text?
>
> My records look something like this:
>
> leak on 4in main
> burst main
> burst 10 inch
>
> In other words, the numbers do not always appear in the same place.
> So how can I just select those records with values in using SQL?
>
>
> Many thanks in advance,
>
>
> Tom
>
> ps Enjoy the weekend and England's victory over our northern
> neighbours!!!!
>
> ------_=_NextPart_001_01BF2D02.A3CC06D0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
> 5.5.2448.0"> <TITLE>MI - selecting number within text</TITLE>
> </HEAD> <BODY>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">Dear list,</FONT>
> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">Second problem in two days, so here
> = goes.....</FONT> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">I have a character column, although
> = some of the records have numbers in them. How do I go about just =
> selecting those records with a number in the text?</FONT></P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">My records look something like =
> this:</FONT> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">leak on 4in main</FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Arial">burst main</FONT>
> <BR><FONT SIZE=3D2 FACE=3D"Arial">burst 10 inch</FONT>
> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">In other words, the numbers do not
> = always appear in the same place. So how can I just select those
> records = with values in using SQL?</FONT></P> <BR>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">Many thanks in advance,</FONT> </P>
> <BR>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">Tom</FONT>
> </P>
>
> <P><FONT SIZE=3D2 FACE=3D"Arial">ps Enjoy the weekend and =
> England's victory over our northern neighbours!!!!</FONT> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01BF2D02.A3CC06D0--
> --------------------------------------------------------------------
> - To unsubscribe from this list, send e-mail to [EMAIL PROTECTED]
> and put "unsubscribe MAPINFO-L" in the message body, or contact
> [EMAIL PROTECTED]
CJ Martin
GIS Consultant
WS Atkins Consultants Ltd
(01952) 201234
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
