Question

这个sql如何写呢？text类型的，不让用比较

select top 8 c.LineID as LineID,ETravelLineName,Price from TravelRegion a,regioncity b,travelline c
where a.regionid=b.regionid and b.departure=c.departure and ETravelRegionName='American West'

错误：The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
如何解决呢？

Answer 1

where a.regionid=b.regionid and b.departure=c.departure and cast(ETravelRegionName as nvarchar)='American West'

Answer 2

ETravelRegionName为Text类型

--------------------------------
把=改为like

ETravelRegionName like 'American West'