use the CONVERT Function.

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

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1050

How to create a login account in ms sql server to access the database engine using "create login" statements?

1142

How optimize sql query with multiple joins in sql server?

900

Explain the commands in sql server?

1038

Difference between LEN() and DATALENGTH() in sql server ?

1104

What are the advantages of using a stored procedure?

1008

How to insert data with null values?

1025

what are different types of backups available in sql server? : Sql server database administration

935

When would you use it?

994

What are data regions?

135

What is indexing a document?

1032

What is a recursive stored procedure in sql server?

1175

How to find out what is the default collation in a database?

1121

what are the core components of SSRS?

129

Define right outer join in sql server joins?

1046