Having worked with the Redgate folks for over three years now, I would say they are more interested in advancing technology and making good products for their customers, reahter than...

It would be interesting to compare the backup restore vs. the current backup champ Redgate SQL Backup........

Also, as the forum sponsor, any word on when Redgate will have a 2008...

Try this:

CREATE PROCEDURE spMyproc(@param1 int) AS

DECLARE @SQL_String varchar(4098)

If ISNULL(@param1,'') = ''

BEGIN

SET @SQL_String  = 'SELECT * FROM Users'

END

IF CHARINDEX('A',@param1,1) > 0

BEGIN

SET @SQL_String  = 'SELECT * FROM Users WHERE USername = ' ...

or, you can use the fixed format method similar to the method you are using now:

 "Provider=Microsoft.Jet.OLEDB.4.0;" & _

          "Data Source=" & strPathtoTextFile & ";" & _

          "Extended Properties=""text;HDR=YES;FMT=FixedLength"""

Fixed length assumes...