question on using SQL string functions

[Dave Parizek]

I am running the following query from within Valentina Studio:

UPDATE Item set storageloc = LEFT(Sku, (locate(Sku, '-')-1))

Sku and storageloc are fields of the table.  Sku's structure is 
something like this: '1032-10200'

I would expect storageloc to become '1032'

but instead it becomes 'LEFT'

What am I doing wrong?

--Dave
-- 
_______________________________________________
Dave Parizek
Bookseller
Dave at Parizek.com