Painful extraction

[Mike Summer]

I want to know how extract part of a field. For each record, I want to extract the last part of an email address. For example if the email address is [email protected], how can I extract 'world.com'. Your reply is much appreciated.

[aaa]

Hi, Mike!

This is one of ways:

Middle ( Email;Position ( Email;"@";1;1)+1;1000 )

You can use Right() function too.

[Mike Summer]

It works perfect. Much appreciated.