Query in QlikView script similar to SQL's "like" function.......

[#1]

Hi.

I have a couple of questions :

(1)  is there a function in QlikView which is similar to SQL's  "like" function.

For example :  I am trying to filter-out valid emails from the "Email" field in my database.

In SQL, it would be as easy as saying :  "Select * from my_customers where email like  '%@%';

(This makes sure that the email contains the symbol :  @  )

Not surprisingly, this does not work in QlikView's script.

How can I accomplish the same thing here?

(2)  the second part of my problem is to create a separate column in QlikView, which would contain boolean values "TRUE" or "FALSE", depending on whether or not the individual has a valid email.

For example :  if the script is loaded, and an individual has a valid email,  the string "TRUE" will be input into this separate field.

If the email is invalid  (for example, does not contain the symbol '@'),  then the value "FALSE" will be assigned to this separate field

Thanks

[#2]

Worked like a charm!

Thanks for all the help.  Much obliged