Expression Builder and Update Query

[Guest]

I am trying to create a query that looks at a single table with a field call
region. The region field begins with the letters SD, format is "SD REGION -
CITY". I would like to remove the SD and CITY from the field leaving no
spaces but only the REGION. I tried to use QUERY Builder with Expression
Builder....here's my valiant stab at it.

UPDATE [X-WMS] SET [X-WMS].REGION_NAME = Replace("SD","",1,1,2);

 

[Guest]

Try this if the field always starts with 'SD ' and only has ' - ' before the
city.

UPDATE [X-WMS] SET [X-WMS].REGION_NAME = Left(Replace([X-WMS].REGION_NAME],
"SD ",""), InStr(Replace([X-WMS].REGION_NAME], "SD ",""), " - ") -3) ;