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

Answers were Sorted based on User's Feedback



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

Answer / guest

use the CONVERT Function.

Is This Answer Correct ?    5 Yes 0 No

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

Answer / sagun sawant

I will convert column with integer datatype to char because
i can not convert char to integer if column contains any
alphabet and then i will compair two values

Is This Answer Correct ?    4 Yes 1 No

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

Answer / rajeevrohilla

You Can USe Either Convert or Cast Function for this

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the default value of an integer data type in sql server 2005?

0 Answers  


what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,


Why use identity in sql server?

0 Answers  


Diffrences between sql server 2000 vs 2008

0 Answers   TCS,


What is the purpose of object explorer and its features? : sql server management studio

0 Answers  


What is blocking?

0 Answers  


What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,


Is oracle faster than sql server?

0 Answers  


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  


Explain nested join?

0 Answers  


What function does a database engine serve in the sql server?

0 Answers  


What is a dbms wizard?

0 Answers  


Categories