Re: Concat alternative

2007-10-26 Thread Gerard
On 10/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Gerard wrote: > > Currently I am running a concat statement to combine a field with a user > > name and domain to create and email address. In testing it looks like > > running the concat is a very slow command to run. The select stateme

Re: Concat alternative

2007-10-24 Thread mysql
Gerard wrote: Currently I am running a concat statement to combine a field with a user name and domain to create and email address. In testing it looks like running the concat is a very slow command to run. The select statement currently looks like this. select concat(user,'@',domain),servername

Re: Concat alternative

2007-10-24 Thread Rob Wultsch
On 10/24/07, Gerard <[EMAIL PROTECTED]> wrote: > Currently I am running a concat statement to combine a field with a user > name and domain to create and email address. In testing it looks like > running the concat is a very slow command to run. The select statement > currently looks like this. > >