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 Administration
 MSG-257

Author  Topic 

dimple
Starting Member

1 Post

Posted - 2013-03-13 : 03:51:12
Hi team
I have been facing an issue of MSG 257

"Msg 257, Level 16, State 3, Line 1
Implicit conversion from data type varchar to timestamp is not allowed. Use the CONVERT function to run this query."

I have to fetch certain data by executing this query
Select * from <tablenamexyz> where columnnameabc = '0000000%XYZ110.2'

kindly sugest me which convert function should I use to resolve this issue.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-13 : 04:26:23
where convert(varchar(32),columnnameabc) like '0000000%XYZ110.2'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -