SqlDbx
You are not logged in.
Pages: 1
Hi,
I'm not sure where's the problem but I fail to RightTrim a string (tested both with SET ANSI_PADDING ON/OFF). Try executing a simple query like:
SELECT RTRIM('352561Â ') and you will get an invalid result: '352561 ' (string is not trimmed)
Correct results are shown only with this query:
SELECT CAST(RTRIM('352561Â ') AS CHAR(6))
Can anyone direct me to the solution please?
Thx guys
Offline
I am unable to reproduce this behavior. It works as expected
What server version are you using?
Offline
Hi,
I'm using version:
Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Any ideas?
Offline
Does this happen only in SqlDbx? What about SMSS?
Offline
I checked, it only happens in Sqldbx...
Offline
This will have to be investigated.
What version of SqlDbx you use and what connection type?
Offline
Hi,
I finally solved the issue by completely closing down the connection (I can't remember the last time I actually closed the connection, I just used reconnecting in Sqldbx)... and connecting again. After that, I could not reproduce this problem, it's working fine fornow! Very strange...
If it helps, I'm using:
Sqldbx version 3.50 Professional Edition
Driver load order: SQL Server Native Client 10.0, SQL Native Client
DBMS type: Microsoft SQL Server
Offline
Pages: 1