Lists Home |
Date Index |
- From: email@example.com
- To: KenNorth <KenNorth@email.msn.com>, firstname.lastname@example.org
- Date: Mon, 28 Aug 2000 09:25:47 -0400
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
> 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.