I have a list of objectives in a mssql table that are ordered by objective
numbers that run 1.0, 1.1, 1.2, 1.3, 2.0, 2.1, 2.2, 2.3, etc.
what i am trying to do is create a char index that will group the objective
numbers by the character before the period in order to get subtotals for all
objective beginging with 1, 2, 3, etc.
this is what i have so far.
ALTER function [dbo].[isSubTotal](@objectiveNo char(10))
returns int
as
begin
declare @periodPos int
set @periodPos = ('.')
if ((charindex('.', @objectiveNo) = 0))begin
return 0
end
return 1
END
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303310
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
