I'm trying to figure out some SQL here and I am wondering this:

Is it possible to select data based on a sub-string of a text field?

Say I have these values in a field called "NAME": "abcd"

Is there any way for me to select records based on all "NAME" fields showing values in the form "a,b,c,d" ?

I have no idea what the proper (if possible) syntax would be, and m badly stuck in the query:

Any help would be greatly appreciated!