SQL format

[li0000]

Hi

There are some different data types. each data type will have special format like:

Select *
From tablename
Where
att1 = 1

when att1 is integer, this will be OK.

But when att is "CHAR"

It should be:

Select *
From tablename
Where
att1 = '1'

My question is:

When data type is "LONFVARBINARY" or some other weird type, how can I write filter?

Where can I find document for it?

Thanks,

[RickCrone]

I find that for SQL numeric type I can use the ' charaters aroung the number and it works fine.

Have you tried this with your 'special' types?

[Ejaz]

[ Redirected Thread ]