Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

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

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

Do you know how to implement service broker?

0 Answers  

Is SET a SQL Keyword?

4 Answers   BitWise,

Ms sql server index?

0 Answers  

Explain what are sparse columns?

0 Answers  

How many full-text indexes can a table have?

0 Answers  

Can we drop user if user mapped to any logins

1 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

What is wide table?

0 Answers  

How to list all tables in the database using odbc_tables()?

0 Answers  

List out the different types of locks available in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories