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

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2495

What is triggers in ms sql server?

1106

Will sql server 2005 allow you to reduce the size of a column?

978

What is scheduled job and how to create it?

977

What is the query and subquery?

1071

What is sql server 2000 work load governor?

1053

What is nonclustered index with included columns ?

956

Explain what are the database objects? : SQL Server Architecture

1068

What is an expensive query?

922

Why use view instead of a table?

936

Is mysql the same as sql server?

968

Why we use the openxml clause?

1000

How to add the custom code in Report?

126

How to create a view using data from another view?

944

What is use of dbcc commands?

1058