Conditional Concatenation

[JohnnyRocket]

Hello,

I am writing a query that will determine how many times a given web page is accessed. Each page name is made up of two parts in the table: 1. Target and 2. Parameters. Not all targets have parameters and if there is no parameter the table has a "-" in the parameter column. I have written the following query but where there is a "-" in the parameter column I don't want the "-" to be displayed (i.e. I just want to diplay the target) Any ideas?

SELECT (Target+Parameters), count(*)
FROM LOGtable
GROUP BY (Target+Parameters);

 

[kulkarnidilip]

Yes, you can use CASE..WHEN statement in select statement.

 

[JohnnyRocket]

Thanks very much.