Post
Ask Question
yokzu

yokzu

  • NA
  • 306
  • 0

Select query problem

Dec 7 2011 7:33 AM
Hi.

I want to a simple select query from Mssql db but its getting error. I wanna search this;
-------------------------------------
"Cisco IOS Software, s4444_rp Software (s4444_rp-ADVIPSERVICESK9-M), Version , RELEASE SOFTWARE (fc6)  Technical Support: http://www.cisco.com/techsupport  Copyright (c) 1986-2008 by Cisco Systems, Inc.  Compiled Wed 16-Jan-09 12:12 by prod_rel"
-------------------------------------

So I am using this query;
-------------------------------------
SELECT * FROM Servers where SysDescr='Cisco IOS Software, s6523_rp Software (s6523_rp-ADVIPSERVICESK9-M), Version 12.2(33)SXH1, RELEASE SOFTWARE (fc3)  Technical Support: http://www.cisco.com/techsupport  Copyright (c) 1986-2008 by Cisco Systems, Inc.  Compiled Wed 16-Jan-08 23:50 by prod_rel'
-------------------------------------

But its getting this error;
-------------------------------------
Msg 402, Level 16, State 1, Line 1
The data types text and varchar are incompatible in the equal to operator.
-------------------------------------

How may I search this?


Answers (10)