<div>
may be something like this<br />
<br />
Select userid, if(catcode01=1,'1-Sales', if(catcode01=2, '2-Accounting','Other') ) catDEtail, , firstname, lastname from users where userid = 5<br />

</div>


may be something like this

Select userid, if(catcode01=1,'1-Sales', if(catcode01=2, '2-Accounting','Other') ) catDEtail, , firstname, lastname from users where userid = 5


<div>
Try this<br />
<br />
Select userid+' '+case catcode01 when 1 then 'Sales' when 2 then 'Accounting' else 'unknown' end +' '+firstname+' '+ lastname from users where userid = 5<br />
<br />
You can add more value of catcode01 <br />
<br />
HuyBD;
</div>


Try this

Select userid+' '+case catcode01 when 1 then 'Sales' when 2 then 'Accounting' else 'unknown' end +' '+firstname+' '+ lastname from users where userid = 5

You can add more value of catcode01

HuyBD;

<div>
Hi ScottParker<br />
<br />
try the following:<br />
<br />
SELECT CONCAT( userid, &quot;&nbsp;&quot;, catcode01, &quot;&nbsp;&quot;, firstname, &quot;&nbsp;&quot;, lastname) FROM users WHERE userid = 5
</div>


Hi ScottParker

try the following:

SELECT CONCAT( userid, " ", catcode01, " ", firstname, " ", lastname) FROM users WHERE userid = 5

<div>
Perfect. &nbsp;Just what I was looking for.
</div>


<div>
<div class="content wysiwyg-content">
Hello<br />
VB.net 2005<br />
mySQL 4.1 backend database<br />
<br />
I have the following sql statement<br />
Select userid, catcode01, firstname, lastname from users where userid = 5<br />
the value that is stored in the user table for catcode01 is a number 1-10.<br />
Without making another table, and doing a join to it, is there a way in the SQL statement to show some text instead of or in addition to the catcode01 field?<br />
<br />
example returned record<br />
123 &nbsp; &nbsp; 1 &nbsp;john doe<br />
124 &nbsp; &nbsp; 1 &nbsp;jane doe<br />
125 &nbsp; &nbsp; 2 &nbsp;frank smith<br />
what I would like it to show is..<br />
123 1-Sales john doe<br />
124 1-Sales jane doe<br />
125 2-Accounting frank smith<br />

</div>
</div>


Hello
VB.net 2005
mySQL 4.1 backend database

I have the following sql statement
Select userid, catcode01, firstname, lastname from users where userid = 5
the value that is stored in the user table for catcode01 is a number 1-10.
Without making another table, and doing a join to it, is there a way in the SQL statement to show some text instead of or in addition to the catcode01 field?

example returned record
123     1  john doe
124     1  jane doe
125     2  frank smith
what I would like it to show is..
123 1-Sales john doe
124 1-Sales jane doe
125 2-Accounting frank smith


SQL statement in mySQL and  VB.net

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.