Comments by kadefgahnna (Top 2 by date)

kadefgahnna 23-Apr-23 20:41pm View

Thanks for the answer @richard but I still got an error using LIKE keyword. Error message: Incorrect syntax near the keyword 'LIKE'.

kadefgahnna 23-Apr-23 20:38pm View

Deleted

Heres a the snippet. to that previous question


WHEN 'PG' THEN 
							CASE SUBSTRING([Remarks] ,1 ,CHARINDEX('-', [Remarks]) - 1)
			
								WHEN 'NP' THEN SUBSTRING([Remarks]
															   ,CHARINDEX('NP', [Remarks]) + 10
															   ,LEN([Remarks])
															   )
								
								WHEN 'RPN' THEN SUBSTRING([Remarks]
															   ,CHARINDEX('RPN', [Remarks]) + 3
															   ,LEN([Remarks])
															   )
								WHEN 'RDPN' THEN SUBSTRING([Remarks]
															   ,CHARINDEX('RDPN', [Remarks]) + 4
															   ,LEN([Remarks])
															   )
								WHEN 'MPD' THEN SUBSTRING([Remarks]
															   ,CHARINDEX('MPD', [Remarks]) + 3
															   ,LEN([Remarks])
															   )
								WHEN SUBSTRING([Remarks], CHARINDEX('-', [Remarks], CHARINDEX('-', [Remarks]) + 1) + 1, LEN([Remarks])) LIKE '%CLP' THEN SUBSTRING([Remarks]
															   ,CHARINDEX('%CLP', [Remarks]) + 17
															   ,LEN([Remarks])
															   )

its giving me error in the CLP part