Problem to concatenate strings in SQL-statements 1

[PascalKlaus]

Is there a common resolution to concatenate strings in SQL-statements on both Oracle and SQL-Server databases.
It doesn't work with "concat", "+" or "||" on both databases.
I don't want to work with:
if IsOracle then ...

 

[lespaul]

are you asking if there is a common function that you can use to concatenate strings if the database is SQL Server or Oracle? I don't think so, but you could always just return the single fields & concatenate in the Delphi code, or alternatively create a calculated field in the query that combines them for you if you need the information in a DBGrid.

HTH


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[PascalKlaus]

I had feared that. Nevertheless - thanks.