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

Answer Posted / guest

use the CONVERT Function.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a store procedure with encryption?

527


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


What do you understand by sql server agent?

538


How do I view views in sql server?

525


What are the authentication modes in sql server? How can it be changed?

607






Does order by actually change the order of the data in the tables or does it just change the output?

699


What are the drawbacks of reporting in ssrs?

108


How to find the service pack installed? : sql server database administration

554


How many types of functions are there in sql server?

469


How to identify current user in ssrs report?

242


Name some of the open source software that you can use in alternative to SSR?

109


What is the purpose of sql profiler in sql server? : sql server database administration

632


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

712


What are the types of joins in sql?

569


Why use sub query in sql server and list out types of sub queries?

551