Update Table problem!

[NavMen]

Hi,

I try to update a table with the following query, the ShPath string is coming from a external source

UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath = 'C:\USERS_100\'

But the ShPath has the entry C:\USERS_100 how can I remove the \ behind the C:\USERS_100\

Thanks,

Navmen

 

[HarleyQuinn]

I'd have a look at the Left() function to start with.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[earthandfire]

... Or the Substring function

 

[checkai]

UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath = right('C:\USERS_100\',len('C:\USERS_100\')-1)

 

[HarleyQuinn]

You mean Left()?

Your posted code returns :\USERS_100\...

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[maswien]

How about this:

UPDATE SHARES SET group='0' WHERE servername='SRV01' and ShPath like 'C:\USERS_100%'

 

[JoeAtWork]

Maswien - I don't think he should use the LIKE operator because it will update records where ShPath = 'C:\USERS_10099', or 'C:\USERS_100_abc\xyz\ufo\', etc.