[mani9597]

for ex

select if (invoice.category)= "DR" then drug else

This post has been edited by Atli: 09 October 2012 - 02:48 AM
Reason for edit:: Use [code] tags when posting code.

[Atli]

The CASE syntax is probably what you are looking for here.

That example is a bit weird though. Depending on what "drug" is supposed to be (a value or a reference to a column?), then there are far better alternatives to using conditional logic like you are attempting to do there.

[mani9597]

Atli, on 09 October 2012 - 02:55 AM, said:

The CASE syntax is probably what you are looking for here.

That example is a bit weird though. Depending on what "drug" is supposed to be (a value or a reference to a column?), then there are far better alternatives to using conditional logic like you are attempting to do there.

"dr" means field value of category column
'drug' means we are return to the application

anyway how to use if condition in sql

thanks for ur reply

[Atli]

mani9597, on 09 October 2012 - 09:59 AM, said:

"dr" means field value of category column
'drug' means we are return to the application

So, basically what you are trying to do there is translate the acronym stored in the table into a full word by using conditionals in the SQL query? That makes no sense. Why not just store the full word in the table with the acronym (in a different column, obviously) and return that directly? That would be far more efficient.

Not to mention that by using conditionals, you'd have to rewrite the query each time you added, removed or modified the values in the table.

mani9597, on 09 October 2012 - 09:59 AM, said:

anyway how to use if condition in sql

I already answered that. The CASE statement is what you are looking for if you want to use conditionals in a SQL query.

This post has been edited by Atli: 09 October 2012 - 03:09 AM

[DarenR]

here is for if else in sql

here

[Atli]

Those are for T-SQL statements (procedures and such), not for normal SQL queries.

[e_i_pi]

Atli, on 09 October 2012 - 09:08 PM, said:

mani9597, on 09 October 2012 - 09:59 AM, said:

"dr" means field value of category column
'drug' means we are return to the application

So, basically what you are trying to do there is translate the acronym stored in the table into a full word by using conditionals in the SQL query? That makes no sense. Why not just store the full word in the table with the acronym (in a different column, obviously) and return that directly? That would be far more efficient.

For future readers, a lookup table would be more efficient still, even though all queries requiring lookup table information necessitate an extra line of SQL to JOIN the information in. The benefits come mainly from the lookup data being stored and referenced in a manner that DBs can handle easily. DBs like integer-key values, as they take up small storage space and allow for easy comparison.