Saturday 11 February 2017

Std 11 Chapter 11 Wild Card Character



  • Wild Card Character Asterisk (*) sign Returns Remaining Character of the Conditions Value.

For e.g. Like ‘M*’: They Returns Name Start with M but Remaining Character after M is Any Character.

Std 11 Chapter 11 Operators Examples in Base


  • 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#

Std 11 Chapter 11 Different Operator Used in Base ?


  • Different Operation Use in Base :



 

Operator
Symbols
Comparison
=,  >,  <,  >=, <=, <>
Logical
And, Or, Not
Special
Like, Is, Between, In

Std 11 Chapter 11 Write Criteria Condition on Particular Field Value


  • Different Ways to Write Criteria Condition on Particular Field Value :


1. Text:            Write Condition value in Single Quotation.
          For e.g. ‘Ahmedabad’
                        2. Number:      Write Condition value as per your Condition.
                                                  For e.g. 12
                        3. Date:           Write Condition Value Before and After Hash Sign (#).
                                                For e.g. #1/1/2014#