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
>
>Hi Dave,
>
>I'm pretty sure this wont be able to do this until version 2.0 is 
>ready. I'm looking forward to this too, being able to use functions 
>inside of queries.
>

If you can't do them inside of queries, can you use them some other 
way?  It seems strange that they are documented in the sql pdf if you 
can't use them yet.  Kind of almost false advertising...

--Dave

-- 
_______________________________________________
Dave Parizek
Bookseller
Dave at Parizek.com