How do I compare two values when one value(data type) is
char and the other is an integer?
- 3 Answers
- 7593 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sagun sawant
I will convert column with integer datatype to char because
i can not convert char to integer if column contains any
alphabet and then i will compair two values
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / rajeevrohilla
You Can USe Either Convert or Cast Function for this
| Is This Answer Correct ? | 2 Yes | 0 No |
What does it mean to normalize a database and why would you do it?
What are the transaction properties?
Can we add our custom code in ssis?
What are audit control procedures?
0 Answers Ernst Young, Thomson Reuters,
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
List out the difference between union and union all in sql server?
What is store procedure? How do they work?
How to use values from other tables in update statements in ms sql server?
What is the difference between row_number and dense_rank?
What are the different types of lock modes in sql server 2000?
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
