Functions

Question 1

Convert to uppercase

Answer 1

UCase([String to be converted to uppercase])

Question 2

Convert to lowercase

Answer 2

Lcase([string to be converted to lowercase])

Question 3

Left trim

Answer 3

Ltrim( string to trim)

*removes leading spaces

Question 4

Right trim

Answer 4

Rtrim(string to trim)

*removes trailing spaces

Question 5

Trim

Answer 5

Trim(string to trim)

*removes both leading and trailing spaces

Question 6

Powerful Case conversion

Answer 6

StrConv(string to be converted, conversion type)

o	1: uppercase characters
o	2: lowercase characters
o	3: proper case characters

Question 7

Between And

Answer 7

Criteria: Between 10 And 30

Question 8

Matching/finding names that begin with “John”

Answer 8

LIKE”John*”

Question 9

Matching/finding names that ends with “son”

Answer 9

LIKE”*son”

Question 10

Matching/finding company names that contain “Food”

Answer 10

LIKE”food”

Question 11

DateDiff

Answer 11

DateDiff(interval, date1, date2)

Question 12

IIF (immediate if)

Answer 12

IIF (Expression, TrueAnswer, FalseAnswer)

Question 13

IIFDATE

Answer 13

IIF(DateDiff(“d”,[Service_date],[Invoice_date]) > 2, “Audit this record”, “Record is OK”)