Subscribe to this thread
Home - General / All posts - converting SQL from 8 to 9
vincent

1,859 post(s)
online
#26-Mar-20 19:24

Hi,

I'm trying to convert this simple query to M9 :

Update [20031901] set [LATITUDENS] = Replace([LATITUDENS], "N" , ""), [LONGITUDEE] = Replace([LONGITUDEE], "W", "")

I tried with no luck :

Update [20031901] set [LATITUDENS] = StringReplace([LATITUDENS], "N" , ""), [LONGITUDEE] = StringReplace([LONGITUDEE], "W", "")

Thank you.

rk
364 post(s)
#26-Mar-20 19:42

SQL9 uses single-quote

--sql9

Update [20031901] set [LATITUDENS] = StringReplace([LATITUDENS]'N' , ''), [LONGITUDEE] = StringReplace([LONGITUDEE]'W''')

Manifold User Community Use Agreement Copyright (C) 2007-2019 Manifold Software Limited. All rights reserved.