Using like in IF

Using like in IF

  
Hello guys

is theres a way to use Like on my IF condition?.

example

{contacts}.name like 'S%'

how can i check if the name starts with  "s"?


thanks,
Hi,

You can use the "Substr" function:
toupper(Substr({contacts}.name,0,1) )= "S"

Hope it helps,
Hermínio
thanks... it works...