Hi Laith,
There are number of ways to select the rivers and creeks. Here are a few:
Select * From .... Where Name Like "% RIVER" Or Name Like "% CREEK"
(Using a wildcard %)
Select * From .... Where Instr(1,Name," RIVER")>0 Or Instr(1,Name," CREEK")>0
(Looking at the position of "RIVER" or "CREEK" in the column)
Select * From .... Where Right$(Name,6)=" RIVER" Or Right$(Name,6)=" CREEK"
(Looking at the last 6 characters in the column)
Select * From .... Where Right$(Name,6)=any(" RIVER"," CREEK")
(Also looking at the last 6 characters in the column)
For a list of all the functions available in a SQL statement, check out the
SQL questions at http://www.spatialplus.com/infobase.htm
Hope this helps.
Regards,
Sue.
++++++++++++++++++++++++++++++++++++++++
adding Susan Port
value Technical Support Coordinator
to [EMAIL PROTECTED]
your
spatial Spatial Plus
systems http://www.spatialplus.com
++++++++++++++++++++++++++++++++++++++++
>Friends,
>
>I have data for all types of watercourses. I want to select only those that
are rivers or >creeks. One of the columns (NAME) differentiates rivers and
creeks from the rest by its >name (eg. Terrania Creek, Brunswick River etc).
>
>What would be the correct syntax to select all rivers and creeks by using this
column?
>
>Also, does anyone know of any good SQL syntax resources, tutorials, teach yourself
by >examples???
>
>
>Thanks in advance,
>Laith
>
>
>=============================
>
>Laith Wark
>
>EDAW (Aust) P/L
>Design, Planning and
>Environments Worldwide
>
>Level 4 Rowes Building
>235 Edward Street
>Brisbane 4000
>Australia
>
>Ph: INT +61 (0)7 3229 6422
>Fx: INT +61 (0)7 3229 6422
>
>Email: [EMAIL PROTECTED]
>
>=============================
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]