SQL expressions

From Wildsong
Revision as of 23:25, 11 September 2018 by Brian Wilson (talk | contribs) (Created page with "ArcGIS SQL expressions Good luck! They vary depending on where your data lives. Try the ancient doc you can download from Microsoft on [https://www.microsoft.com/en-us/downl...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

ArcGIS SQL expressions

Good luck! They vary depending on where your data lives.

Try the ancient doc you can download from Microsoft on SQL 2000.

I need to split a string and get the elements

SELECT * FROM table WHERE CONVERT("Town" AS STRING) <> SUBSTRING("MapNumber", 1, CHARINDEX('.', "MapNumber"))

Retrieved from "https://wiki.wildsong.biz//index.php?title=SQL_expressions&oldid=11118"