Where Column_name > 'Space' - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Where Column_name > 'Space'

Author

Topic

ricky_newbee
Posting Yak Master

126 Posts

Posted - 2005-01-14 : 10:14:46

Guys,
I have a query, which is an
Insert into table_name
Select
Column1 = sum(coumn2)/Sum(column3)*100
from table1
where
Column5 > " "

What i need here is in where condition i want column5 > a space ie " ". I cannot run this query i am getting an error. can any one tell me how do i achive this.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-01-14 : 10:17:42

where
Column5 > ' '

Make sure you understand how < and > operator with varchar() values -- it may not be what you are expecting.

- Jeff

ricky_newbee
Posting Yak Master

126 Posts

Posted - 2005-01-14 : 10:23:17

Thanks Jeff....
I appriciate your help and suggestion!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources