U++ forum: Welcome to the forum

Thu, 26 June 2008 15:02

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Like has now case sensitive parameter (default: false). In fact it works only with postgres which on default is case sesitive (opposite to mysql or mssql) and if a value of this parameter is false postgres uses ilike command. Example:

SQL * Select(ID, NAME)
.From(PERSONS)
.Where(Like(NAME, "%JA%", true))

output:

select id, name from persons where name like '%JA%'

SQL * Select(ID, NAME)
.From(PERSONS)
.Where(Like(NAME, "%JA%"))

output:

select id, name from persons where name ilike '%JA%'

Report message to a moderator