The Weird and The Wonderful

public static bool UniqueAssetNo(int assetId, string assetNo)
        {
            //--string sql = @"Select Count(*) From Asset " +
            //--				@"Where ({0} = 0 Or AssetId <> {0}) " +
            //--				@"And (LoanNum Not Like '%[A-Z]%') " +
            //--				@"And (Cast('{1}' As bigint) = Cast(LoanNum As bigint))";
            //We ran into an error during testing. I think it has to do with the indexes not being created properly. In either case, this one works.
            try
            {
                string sql = @"Select Count(*) " +
                    @"From (Select AssetId, LoanNum " +
                    @"	From Asset (NOLOCK) " +
                    @"	Where ({0} = 0 Or AssetId <> {0}) " +
                    @"	And (LoanNum Not Like '%[A-Z]%') And LTrim(RTrim(LoanNum)) <> '') qry " +
                    @"Where Cast('{1}' As bigint) = Case When qry.LoanNum = '' Then 0 else Cast(qry.LoanNum as bigint) end";
...
...