Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Syntax

SIMILARTO(string: <String>;pattern: <String>)

Description

The SIMILARTO function returns ‘true’ if its pattern matches the given string otherwise returns ‘false’. It is similar to the ‘LIKE’ function, except that it interprets the pattern using the SQL standard's definition of a regular expression.

Example

SIMILARTO('xyz';#testcsv!Column1)

Column_1

SIMILARTO

xyz

true

x

false

%(y|a)%

true

(y|z)%

false

  • No labels