Hi, Already I have developed this type of tool. Send your personal E-Mail, I'll send the application.

there is no such option in "adapter.allfill", check once. :(

'IsMSShipped' means "Object created during installation of SQL Server 2005". Possible output is 1 - True, 0 - False. For more information see the SQL Server 2005 BOL. :)

try like: select max(OrderNo), max(orderDate) from

what is your front-end ? :confused:

Using enterprise manager you can change the database file grow size or use ALTER DATABASE command. see SQL Server 2005 BOL.

see the URL: http://msdn2.microsoft.com/en-us/library/ms157198.aspx Kishore.P

Modified your code, see the below code: declare @exp varchar(100) , @start int , @pos int , @substring varchar(20) set @exp = '12,13,14' --set @pos = 1 set @start = 1 set @pos = charindex(',' , @exp , @start) -- Added here while(@pos <> 0) begin --set @pos = charindex(',' , @exp , @start) if(@pos = 0) begin print substring(@exp , @start , len(@exp)) return end print substring(@exp , @start , @pos -1) set @pos = charindex(',' , @exp , @start) -- Added here set @start = @pos + 1 end go :) Kishore.P

Can u try the following: -- Code declare @ExpList varchar (1000) , @Delimiter char (1) , @INTValue varchar (20) , @Position int begin create table #Result ( IntValue int ) set @ExpList = '10, 11, 12, 13, 14' set @Delimiter = ',' set @ExpList = ltrim (rtrim (@ExpList)) + @Delimiter set @Position = charindex (@Delimiter, @ExpList, 1) if replace (@ExpList, @Delimiter, '') <> '' begin while @Position > 0 begin set @INTValue = ltrim (rtrim (left (@ExpList, @Position -1))) if @INTValue <> '' begin insert into #Result (IntValue) values (cast (@INTValue as int)) end :) set @ExpList = right (@ExpList, len (@ExpList) - @Position) set @Position = charindex (@Delimiter, @ExpList, 1) end end select * from #Result truncate table #Result drop table #Result end go Sample OUTPUT: -------------- IntValue --------:) 10 11 12 13 14 -- End of Code Kishore.P