General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
Ok Thanks for all your comments
I was aware of the alernative == , but was just trying to find an explanation of why it would not work !!
Regards,
Gerard
>It's how VFP does with string comparisons.
>
>The item on the left is compared up to the length of the field on the right. Because length on the right has a length of 0, it basically looks at SUBSTR(right, 0, 0)
>
>Try SELECT * from MyTable WHERE MyField == ""
>
>The double equal sign means exactly equal
>
>>Hi
>>Why does the following select ALL rows ?
>>Select * from MyTable where MyField = '' && Two single quotes without a space in between
>>
>>Does not matter whether Set exact is on ot off
>>Tia
>>Gerard
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only