"Mike Hoff" <mike@home.com> wrote in message
news:10ogkb49812038f@corp.supernews.com...
>I am trying to make a query that returns different strings added to a
>field,
> depending on the value of another field. The following pseudo-sql
> demonstrates what I would LIKE to do. I hope this makes sense. Table has
> 3
> fields: RecID - int, RecCode - int, RecName - varchar.
>
> SELECT RecID, [IF (RecCode=1 then 'one'+RecName) ELSE IF (RecCode=2 then
> 'two'+RecName) ELSE ('neither'+RecName)] as MyName
>
> Any help appreciated.
>
>

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:epNsNDWwEHA.4040@TK2MSFTNGP11.phx.gbl...
> You can use CASE like in the example below. See the Books Online for
> details.
>
> SELECT
> RecID,
> CASE RecCode
> WHEN 1 THEN 'one'+RecName
> WHEN 2 THEN 'two'+RecName
> ELSE 'neither'+RecName
> END AS MyName
> FROM MyTable
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Mike Hoff" <mike@home.com> wrote in message
> news:10ogkb49812038f@corp.supernews.com...
> >I am trying to make a query that returns different strings added to a
> >field,
> > depending on the value of another field. The following pseudo-sql
> > demonstrates what I would LIKE to do. I hope this makes sense. Table
has
> > 3
> > fields: RecID - int, RecCode - int, RecName - varchar.
> >
> > SELECT RecID, [IF (RecCode=1 then 'one'+RecName) ELSE IF (RecCode=2
then
> > 'two'+RecName) ELSE ('neither'+RecName)] as MyName
> >
> > Any help appreciated.
> >
> >
>
>