使用CLR在c#中执行SQl查询

I am using SQl CLR for parsing some table column. I want to execute the queries also in C# user defined function. Can somebody give an example to execute select and insert queries in the function?I am using SQl CLR for parsing some table colum