xml-dev - Re: XML and LDAP: Common APIs?

[tpassin@home.com]

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