string count in ASP

[rahul]

Hi,

Is there something wrong with this statement?

SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT LIKE '%SR%'

This colum has various values such as 1, 2, SR all I want is the number of records that have the value SR in them.

Also are you able to make calulations to recordsets, for example

producta = 20
productb = 30
productc =40

((Sum (producta) + sum (productb) + sum (productc)) / (Sum (productc)))

to give me a percentage?

Thanks in advance for your replies -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[vikasrocks]

Try the following

Code:
<%
Dim Checkvalue
CheckValue="SR"
strquery="SELECT COUNT(applod.CAT) AS CATSR FROM applod WHERE applod.CAT=" & Checkvalue
%>

As for the maths on your results, you should be able to write ASP code via loops etc to add up your values, divide them, multiply them etc. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --