Is there the ability to us IsNull in the select statement like the following...

Select IsNull(field1, field2) From SomeTable

I know it was discussed in the following thread...

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=1760

Which pointed to creating an IExpression implementation similar to the following thread.

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829

Just wanted to see if there was a better way to do this or if there was a plan to add this.

Thanks!

Having your select statement in a database view is another way of doing it. Then map the View to an Entity or a TypedView, whatever suits you more.

No way is better than the other, it depends on your personal preferences.