You Can USe Either Convert or Cast Function for this

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

Question Posted / rajeevrohilla

Answer Posted / rajeevrohilla

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to insert a new row into a table with "insert into" statements in ms sql server?

975

How to send email from database?

1015

Explain what is dbcc?

1010

What do you know about normalization and de- normalization?

925

What’s the distinction between dropping a info and taking a info offline?

1038

How to add the custom code in Report?

126

Differentiate between ms sql server reporting services vs crystal reports?

905

How global temporary tables are represented and its scope?

977

What is nonclustered index with included columns ?

967

How does a profiler work?

935

What is database replication? What are the different types of replication you can set up in sql server?

958

Can two tables have the same primary key?

1208

What does dml stand for?

948

Where sql server user names and passwords are stored in sql server? : sql server database administration

1056

Explain primary key in sql server?

1018