SQL Server 2005 where condition with string comparison

Ask Time：2010-08-06T12:32:52 Author：Anto Varghese

I am using SQL Server 2005 with the following query

SELECT * 
FROM EMPLOYEE 
WHERE EMP_NAME = 'ABCD'

It gave me the proper results and when i tried the same query with 'ABCD ', then also it gave me the same result!!!

I feel it should not give any results as there is no employee with name 'ABCD '

Or "WHERE" condition works like this with String comparison?

Author:Anto Varghese，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/3421003/sql-server-2005-where-condition-with-string-comparison

More about “SQL Server 2005 where condition with string comparison” related questions

SQL Server 2005 where condition with string comparison

I am using SQL Server 2005 with the following query SELECT * FROM EMPLOYEE WHERE EMP_NAME = 'ABCD' It gave me the proper results and when i tried the same query with 'ABCD ', then also it gave...
Is performance of DB slow in sql server 2005 express compared to sql server 2005 enterprise?

Is performance of DB slow in sql server 2005 express compared to sql server 2005 enterprise ? Comparison between sql-server 2005 and express 2005 is here Comparison between sql-server 2008 and ex...
Can i use column number instead of column name in where condition of a select query in SQL Server 2005?

can we use column number instead of column name in where condition of a select query in SQL Server 2005 so that even if the column name is so long. thanks in advance.
SQL Server 2005: Select statement in ISNULL condition

Environment: SQL Server 2005 I have a stored proc which receives comma separated value in one parameter. I have written a Table Valued UDF function in SQL to break it and and return me it as a tab...
compare ntext by string in sql server 2005 by linq

How can I compare ntext type in sql server 2005 to string with linq? in sql server 2005; @a as ntext linq in c#; string b; var k=from p in DataContext.TableName where p.a.toString()==b) sel..
Concatenating String in SQL Server 2005

Does anyone know how I would go about concatenating a string in SQL Server 2005. What I mean is something like the following scenario. I have a nvarchar(MAX) column in a SQL Server 2005 database....
Array comparison using SQL 2005. Error converting

Ok, no idea why a multi-billion dollar company skimps on array functions for their flagship SQL servers This is why people use MySQL Server. Ok, enough ranting. Using SQL 2005. Let's say i receive...
String comparison in SQL Server 2008

Does SQL Server 2008 have a string comparison method that checks which string is supposed to come first (ex 'abc' comes before 'abd' etc)? I need to do a <= comparison.
Where does SQL Server 2005 keep the .mdf files?

I'm upgrading from SQL Server 2005 to 2008. I've detached the database I need, but can't find it on the file system. Where does a default installation of SQL Server 2005 store these?
SQL Server 2005 Compact and SQL Server 2005

Can SQL Server 2005 Compact Edition be installed in the same server environment as SQL Server 2005? Thank you!

SQL Server 2005 where condition with string comparison

SQL Server 2005 where condition with string comparison

Is performance of DB slow in sql server 2005 express compared to sql server 2005 enterprise?

Can i use column number instead of column name in where condition of a select query in SQL Server 2005?

SQL Server 2005: Select statement in ISNULL condition

compare ntext by string in sql server 2005 by linq

Concatenating String in SQL Server 2005

Array comparison using SQL 2005. Error converting

String comparison in SQL Server 2008

Where does SQL Server 2005 keep the .mdf files?

SQL Server 2005 Compact and SQL Server 2005

热门文章

jpg图片怎么转换成pdf，详细教程分享！

iphone怎么把图片转成电子版？试试这2个方法！

图片如何转换pdf文件？看看这三个方法！

怎么把图片转换成pdf格式，干货教程不要错过

png图片怎么转换成pdf，实用方法不要错过

图片怎么转pdf格式？三种转换方法分享给你，一分钟轻松解决

图片转pdf格式怎么弄免费？get这五个简单的方法，轻松搞定！

如何将图片转pdf格式？4种转换方法分享给你，一分钟轻松解决

如何图片转pdf免费？快学习这三种免费转换方法

怎么将图片转pdf？分享个图片转pdf在线免费

相关搜索

jpg图片怎么转换成pdf，详细教程分享

电脑图片转pdf工具怎么用

单张pdf图片转照片格式

如何将图片转成pdf文档，经验分享

这么好用的图片转pdf软件，我一定要分享

干货分享，不懂图片转pdf的朋友快快收藏起来

分享一个让你惊叹不已的图片转pdf方法

图片转pdf工具

分享一个大家都不知道的图片转pdf格式方法

好用的图片转pdf软件要和好朋友分享