Ah... I will try that. Is this unique to a char(1) field?

In this case I can test for a char(1)='X', but I assume you could not do the same thing for say char(3)='USA' as you would need use char(3)="USA"






>
>Did you try:
>
>where p.status == 'A'
>
>"A" is a string... 'A' is a char
>
>http://msdn.microsoft.com/en-us/library/aa691087(VS.71).aspx
>http://msdn.microsoft.com/en-us/library/aa691090(VS.71).aspx