I re-created the stored procedure and it is working now, but I cannot get it working with INT.

USE tempdb

CREATE TABLE test (LoanNum VARCHAR (10) PRIMARY KEY CLUSTERED, OfficeID INT )

INSERT INTO test VALUES ('100001', 1)

INSERT INTO test VALUES ('100002', 2)

INSERT INTO test VALUES ('100003', 3)

EXEC DBAdmin.dbo.usp_String_Search

@v_Search_String = '2'

,@v_Database_Name = 'tempdb'

,@v_Data_Types = N'INT'

DROP TABLE TEST