Concatened Parametes

[angjbsca]

Hi How I do this:

select * from t1 where f1 like '%joe%'
with parameters
I try this but does not work;
select * from t1 where f1 like '%' || ? || '%'

 

[PruSQLer]

It's not clear to me what you're trying to do. Could you elaborate...

 

[angjbsca]

Im working with report application and db2 so,
if I send a query with parameters I do that:

select * from t1 where f1 = ? where ? is the param thats query work fine.

but if I use "Like" with wild cards "%" in .net with sql
I do that:

select * from t1 where f1 like + "'%" + ? + "&'"
but in db2 that king of query do not work for me.

 

[MarcLodge]

From within your .net application can you append a % to the value. For example if the value is 'Tek', set it to 'Tek%'.

Your sql would then read:
select * from t1 where f1 like ?

Hope this helps.

Marc