Dear Avinash,
Project: Doctor on wheels.
We have identified the Hemoglobin level some value as text values it's like 10g, hi.
Please find the below screenshot for your reference.

Query:
select CreatedDate,BeneficiaryRegID,VisitCode,ProcedureID,TestComponentID,TestResultValue,TestResultUnit,Deleted,Providerservicemapid
from t_lab_testresult where ProcedureID=29 and
TestResultValue like '%g%' or TestResultValue like '%h%';