I am not sure exactly how I am to work in the coalesce function to get the result, I tried some experiments and I could get the first and or second fields in another column, but not as part of the bracketed group.
This is the argument as it stands now, (without the coalesce function) how should I introduce the coalesce function to get the desired result? SELECT '( ' ||(select English1)|| ', ' ||(select english2)|| ', ' ||(select english3 )|| ' )' AS English FROM UniqueAramaic4; I apologise if this sounds like a silly question, but I am new to SQL and am trying to get syntax, order and function use straight in my head. Cheers, Tim. Igor Tandetnik wrote: > > Macgyver7 <t...@buffaloriverforge.com> wrote: >> Thanks Igor, that works, however there is a problem. This will only >> return a >> result when there are no null fields in the last two columns. The first >> column has results in every field, but columns 2 and 3 don't have results >> in >> every field. How do I get around this not returning anything when there >> are >> null fields? > > coalesce((select ...), '--'); > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Most-Frequent-Occurrence-Problem-tp32900981p32906732.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users