Thread: How do i compare NUMBER to VARCHAR?
View Single Post
  #2 (permalink)  
Old 12-14-2006, 12:44 AM
EvilOverlord EvilOverlord is offline
Junior Member
  
Join Date: Dec 2006
Posts: 2
EvilOverlord is on a distinguished road
Default ANY answer. Re: How do i compare NUMBER to VARCHAR?
Use the CONVERT command:
[sql]
where mynumber = CONVERT(int,mycharacters)
[/sql]
Reply With Quote