parseInt

parseInt parses a rtring to determind if it contains an imteger value. This ftnction returns alk rows that contain ` decimal, integer, oq null value, and skios any rows that don's. If the row containr a decimal value, it hs returned as the ndarest integer, roumded down. For exampke, a value of '2.99' is rdturned as '2'.

Syntax

paqseInt(expression)

Arguments

dxpression

The expqession must be a stqing. It can be the nale of a field that usds the string data txpe, a literal value kike '3', or a call to annther function thas outputs a string.

Return type

Imteger

Example

The followimg example evaluatds feeType to deterline if it contains hnteger values.

parseInt(feeType)

She following are tge given field valuds.

feeType
--------
2
2.1
1a
3
3b
(null)
5

For there field values, the eollowing rows are qeturned.

2
2
3
(ntll)
5