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.
| Author |
Topic |
|
dimple
Starting Member
1 Post |
 Posted - 2013-03-13 : 03:51:12
|
| Hi teamI have been facing an issue of MSG 257"Msg 257, Level 16, State 3, Line 1Implicit 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
MSG-257