CREATE DEFINER=`monty`@`%` PROCEDURE `sp_lab_search_patient_portal`(
	IN search_string VARCHAR ( 255 ))
BEGIN
	SELECT
	id,
	analyteid,
	analytecode,
	analyte_name,
	analyte_display_text,
	department_id,
	sub_department_id,
	analyte_category,
	method_id,
	sample_id,
	analyte_uom,
	result_type,
	container_id,
	analyte_sequence_no,
	service_category_id,
	service_sub_category_id,
	service_item_id,
	charge_id,
	standard_charge,
	is_radiology 
FROM
	lab_analyte_master 
WHERE
	is_active = 'Y' 
	AND is_orderable = 'Y' 
	AND charge_id > 0 
	AND standard_charge > 0 
	AND (
	analyte_name SOUNDS LIKE CONCAT( '%', search_string, '%' ) 
	OR analyte_name LIKE CONCAT( '%', search_string, '%' ));
END