see updated below
CREATE PROCEDURE GET_DISTINCT_FIELD_VALUE
@FIELD_NAME nvarchar(50),
@TABLE_NAME nvarchar(59)
AS
BEGIN
declare @q nvarchar(max)
set @q = ' select distinct '+ @FIELD_NAME+' FIELD_VALUE from ' + @TABLE_NAME + ' where len('+@FIELD_NAME +') <> 0 and ' + +@FIELD_NAME + ' Is not null order by '+@FIELD_NAME +' asc'
exec (@q)
END