Some Important Operators Examples:
|
No.
|
Name of Operators
|
Examples
|
|
1
|
And
|
1. 100 And 200 2. ‘Anand’ And
‘Nadiad’
|
|
2
|
Or
|
1. 100 Or 200 2. ‘Maulik’ Or ‘Paresh’
|
|
3
|
Not
|
1. Not 5 2. Not(‘Anand’)
|
|
4
|
Like
|
1. Like ‘M*’
|
|
5
|
Is
|
1.Is Not Empty (The Field Value is
not Set Empty)
|
|
6
|
In
|
1.In(‘Anand’)
|
|
7
|
Between
|
1.Between #1/6/2005# And #11/1/2012#
|
No comments:
Post a Comment