Query to get Count of 2 different columns and then Sum their values in SQL Server

baijuep

I WAS CREATING A FUNCTION IN SQL 2005

i want to count 'YO' in YO field

i want to count 'YO' in RMK field

and then add both value together (eg if YO count value=5 and rmk YO count value=2 then i want 5+2=7)

i tried the + but gives error in my query

select @Count = COUNT(*) from COURSE_intake where YO in ('YO') + RMK LIKE 'YO%' and ENTRY_COURSE = @ENTRY_COURSE

baijuep

0 8

CAST(dbo.getYOCount(ENTRY_course) AS INT) + CAST(dbo.getdtlCount(ENTRY_course) AS INT) AS 'Avl Deg' ,

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html