create  function fun002(@thename varchar())

returns int

as

begin

declare @count int

select @count=count(@thename) from cm_ads

return @count-

end

select dbo.fun002('ads_id')

 select   *,  dbo.fun002('ads_id') from  cm_ads