ilike comparison involving attributes and wildcards...

The query below seems like a lame hack to me:

SELECT some_column
FROM some_table
WHERE '$some_string_var' ILIKE '%' || some_column || '%';

Is there a more elegant way of comparing a value with a wildcarded column?

TIA,

SoA