mlapl1
Posts: 66
|
| Posted: 02/07/2009, 6:45 PM |
|
I am trying to add a condition to the WHERE part of my query using the visual query builder. The condition is that the field called "Published" should be equal to the letter y.
I would like to put that condition in the WHERE clause: in other words, i want the field to be equal to a literal - or a single char.
i have tried every combination of characters that I know to make the comparison work, but nothing is happening.
Any idea?
Thanks a lot
Andrew
|
 |
 |
damian
Posts: 838
|
| Posted: 02/07/2009, 6:59 PM |
|
change "type" to expression
if using characters/words to match enclose in ' '
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
|
