SQL expressions

From Wildsong
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"))