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

What is a sql join?

952

Explain about extended stored procedure?

863

List all the types of user-defined functions?

991

What is a view in sql?

927

What is the use of sql profiler in sql server 2012?

841

how to take backup bcp out for a column in table in sql server?

2044

What is difference between line feed ( ) and carriage return ( )?

853

What is service broker?

955

Explain what are the restrictions while creating batches in sql server?

1021

Can one drop a column from a table?

965

What is data set in report?

121

How adventureworkslt tables are related?

879

How to recompile stored procedure at run time?

1005

How do I install only the client tools of sql server 2000?

991

Explain few of the new features of sql server 2008 management studio

859