SQLStrLike - DataDictionary

Helper function that will create an SQL LIKE string for a table column and a target value to be used in the WHERE clause of SQL statements

Type: Function

Return Data Type: String

Parameters: Integer iField String sSearch

ParameterDescription
iFieldTable column to create statement for
sSearchSearch string


Return Value

A LIKE string to be used in the WHERE clause of an SQL statement.


Syntax 
Function SQLStrLike Integer iField String sSearch Returns String

Call: Get SQLStrLike iField sSearch to StringVariable


Description

This is a helper function that will create an SQL LIKE string for a table column and a target value to be used in the WHERE clause of SQL statements

SQLStrLike will always add the N prefix to the result string, making this function work when used against any backend and Unicode data.

Sample

For example, this sample would return the value "Customer.Name LIKE N'%ab%'" in sFilter.

Get SQLStrLike field Customer.Name "ab" to sFilter