Thanks Nick, unfortunately I have already tried this. What I forgot to
mention was that the column might have more than one space
eg "the portakabin 43"
Malcolm Norman
GIS Development
Engineering & Design Services
Portsmouth City Council
UK
-----Original Message-----
From: Nick Hall [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2000 16:35
To: Norman, Malcolm
Subject: Re: MI-L MI SQL
Malcolm,
first off create an new column then update column with :
right$(fieldname,instr(1,fieldname," "))
this should select everything to the right of the space.
to find character strings that begin with numbers use
left$(fieldname,1) in ("1","2", "etc")<>0
Hope this helps
Nick Hall
InfoTech Enterprises Europe
(previously Dataview Solutions)
Technology House, Lissadel Street
Salford M6 6AP
ENGLAND
**WE HAVE CHANGED OUR NAME TO INFOTECH ENTERPRISES EUROPE - PLEASE AMEND
YOUR RECORDS**
Tel: +44 (0)161 278 2557
Fax: +44 (0)161 737 7700
E-mail: [EMAIL PROTECTED]
WEB: www.infotech-europe.com
_______________________________________________________
WARNING - THIS E-MAIL TRANSMISSION IS CONFIDENTIAL.
This e-mail transmission (including any accompanying attachments)
contains confidential information which is intended for the named
addressee only. If you are not the intended recipient, you are hereby
notified that any use, dissemination, distribution or reproduction of
this e-mail is prohibited. If you have received this e-mail in error please
contact us immediately at [EMAIL PROTECTED]
Thank you.
_______________________________________________________
----- Original Message -----
From: Norman, Malcolm <[EMAIL PROTECTED]>
To: Mapinfo-l (E-mail) <[EMAIL PROTECTED]>
Sent: 11 December 2000 15:51
Subject: MI-L MI SQL
> Hi Listers
>
> I need to be able to select all characters to the right of the last space
in
> a column eg PORTAKABIN 14/14A
> also
> how do I select from a character field just entries that are pure
intergers
> eg select '247' but not '24-56' or 45a
>
> Many thanks
>
> Malcolm Norman
> GIS Development
> Engineering & Design Services
> Portsmouth City Council
> UK
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
**********************************************************************
This footnote confirms that this email message has been swept for
the presence of computer viruses and none were found.
Portsmouth City Council. IT Services
**********************************************************************
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
