check if string contains substring sql
Declare @mainString nvarchar(100)='Amit Kumar Yadav'
---Check here @mainString contains Amit or not, if it contains then retrun greater than 0 then print Find otherwise Not Find
if CHARINDEX('Amit',@mainString) > 0
begin
select 'Find' As Result
end
else
select 'Not Find' As Resultsql query to check if column contains alphabets
SELECT *
FROM table_name
WHERE CAST(PRIME_KEY AS STRING) RLIKE '([0-9]+[a-z]+)'Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
