mid function

[newcf]

The email address is not alway in order. Users are not alway have all three
emails address, some time one, or two. It dosen't matter howmay email address
they have, all I need is just find the email which contains domain @os.com.
Here is the example data I have and here are my two questions:

1) How would I output only the email have domain @os.com
2) If #1 is impossible to do it, then would I output all three emails and
sperate them by common (,) I tried the code below but I can't make it work.
Please help -thanks
************************************************** ****

<cfset email ="als@es.com: la.l.smi@escom: [email]aa.l.smith@os.com[/email] added to E-mail
(subjectAltName) for.......>
<cfset fieldValue2 = mid(find('added','email',2),1,1)>
<cfoutput>#fieldValue2#</cfoutput>

[Dan Bracuk]

If in a query

where email like '%@os.com'

If in cold fusion
if(right(email, 7) is "@os.com")
do something