We have a view which reads from our email database (MS Exchange) through LDAP. For some users it returns user@gmail.com, for other users it returns juan@gmail.local, we want the view to return always, user@gamil.com.

• vamshikrishnaeee

  SSCrazy

  Points: 2519

  More actions

  April 7, 2010 at 10:49 am

  #220281

  HI,

  We have a view which reads from our email database (MS Exchange) through LDAP. For some users it returns user@gmail.com, for other users it returns juan@gmail.local, we want the view to return always, user@gamil.com.

  Thanks,

  Vamsy

• Ray K

  SSC-Dedicated

  Points: 31163

  More actions

  April 7, 2010 at 11:12 am

  #1147575

  How about something like . . .

  select EmailAddr from DB where EmailAddr like '%@gmail.com'???

  +--------------------------------------------------------------------------------------+
  Check out my blog at https://pianorayk.wordpress.com/