String operators

These are operators that a used to change and convert character strings:

ASCII

converts an integer operand into its corresponding ASCII character

CLIPPED

takes a character operand and returns the same character value, but without any following spaces

Сoncatenation (||)

joins two operands of any simple data type and returns a single string

LIKE

tests whether a character value matches a quoted string (uses % and _ as wild cards)

MATCHES

tests whether a character value matches a quoted string (uses * and ? as wild cards)

SFMT()

passes a string with variable parameters in it

Sub-string ([])

specifies a sub-string of its operand

USING

formats numeric, MONEY, or DATE operands as character strings

 

Contact Us

Privacy Policy

Copyright © 2024 Querix, (UK) Ltd.