hi !!

following SQL query is not working on SQL Server

"Select * from myTable Where True"

this query gives error "Incorrect syntax near 'True'" on SQLServer
but on MS Access this query works without error !!

Pl. help me out

SPD

The WHERE clause in SQL contains a list of search conditions. Each search condition is made up of one or more predicates. And, a predicate is an expression which evaluates to TRUE, FALSE, or UNKNOWN. The only way to generate this boolean value is by evaluating an expression. Thus in your situation you'll need to provide an expression which always evaluates to TRUE, such as:

Select * from myTable Where 1 = 1

The fact that Access allows the string 'True' to be interpreted as a boolean value is interesting, but nobody ever said that Access was truly an SQL standard implementation. Far from it, in fact...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

You're right about Access not being standard SQL but in the original SQL it is not treating a string as True, that would be Select * from myTable Where 'True'. In Access you are allowed to use VBA in queries and in VBA True is a constant evaluating to true.

--

Joe (Microsoft MVP - XML)

Yup, my bad. The 'true' in there was not a string and I misspoke. In SQL it's not a reserved word either, so the query could not be parsed, resulting in the original syntax error.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

I THINK THE SYNTEX IS NOT RIGHT. YOU HAVE TO STATE WHAT'S EQUEL TO true.
Example
SELEC * FROM mytableName WHERE paid= true

NOTE: "paid" must be field in your table.
I hope it will work for you.

Also as a suggestion avoid using where equal to "true" in vb their numberic value for true is different to sql as well as other applications. Thus true is not always equal to true if you go between applications (vb to sql) for example. I suggest you use a bit and determine which is true 0, or 1 for your application because between the tools it's not consistent even within MS apps.