Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 4, 2000

Data Type

Question:
How do I compare two values when one value(data type) is char and the other is an integer?

Answer:
For this you can use the CONVERT function. Since you can't convert character data to numbers, you'll have to convert the integer column to character. Assuming you have a table called TestTable with two columns:

IntCol int
CharCol char(10)

with these values

IntCol   CharCol
------   -------
1         1
2         2
3         xyz
4         5
You can use this query to SELECT rows based on a comparison:
SELECT *
FROM TestTable
WHERE CONVERT(char(10), IntCol) = CharCol

IntCol      CharCol    
----------- ---------- 
1           1         
2           2
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date