Cart
[Home] [By Thread] [By Date] [Recent Entries]
KenNorth wrote - > > I don't think you need to know the datatype to form the query - > > Here are two SQL queries for which the filter is expressed differently based > on the type of the employee ID (empID) column. To match a numeric ID, you > use the first query. To match a character string ID, you use the second: > > select emp_name from employee where empID = 200 > > select emp_name from employee where empID = '200' > > The type was stated when the table was created. > I know you can come up with examples, but for this particular example, many databases actually do return the same results. SQLAnywhere, which I have used a lot, does so. Just change the "equals" to a "greater than", though, and you will have made the point. Tom Passin
|
