filter stored procedure - 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

General SQL Server Forums

New to SQL Server Programming

filter stored procedure

Author

Topic

eugz
Posting Yak Master

210 Posts

Posted - 2008-06-17 : 16:45:56

Hi All
I try to filter stored procedure:

procedure [dbo].[sp_HomePhone]
as
Select
FName + ' ' + LName Name 
,PhoneHome
from dbo.PhoneBook
where Country is null and PhoneWork = ' '

After execution I got an error:
Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.
What wrong in my filter?
Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-18 : 01:17:59

this may be due to difference in collation settings of the two column. Have a look at collation settings for the column involved using sp_help tablename and then use explicit collation setting in query using COLLATE clause.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-06-18 : 01:32:10

Further to the first response , could you post your table definition. Essentially , when you merge 2 columns this can cause this type of error

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources