select * from MyTable where LEN(rtrim( MyField) ) > 0

Is the above efficient method or there is a better approach?

I don't know if there is a better approach or not, but to make it more robust, you should modify it like so:

select * from MyTable where LEN(ltrim(rtrim( MyField)) ) > 0