nicht angemeldet
Hello,
Ich habe folgende SQL Abfrage für MSSQL
SELECT (CASE WHEN len(feld1)>0 THEN feld1 ELSE feld2 END) as feld FROM tabelle
VBA:
SELECT IIF(Len(feld1) > 0), feld1, feld2) AS Feld
MfG
Rouven
--
-------------------
Ambition is the last refuge of failure. -- Oscar Wilde (Irish Poet, Novelist, Dramatist and Critic, 1854-1900)
-------------------
Ambition is the last refuge of failure. -- Oscar Wilde (Irish Poet, Novelist, Dramatist and Critic, 1854-1900)