Sql

Search

How to find string in substring in sql server

DECLARE @mainString NVARCHAR(100)='Rasel Ahmed'

IF CHARINDEX('Rasel',@mainString) > 0 -- return boolean: 1 OR 0
BEGIN
	PRINT('Yes');
END
ELSE
	PRINT('No')

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql create table index
Sql :: sql count more than 1
Sql :: postgresql regex extract a word from string
Sql :: mysql disable triggers
Sql :: dbms_metadata.get_ddl table
Sql :: len sql
Sql :: postgresql newline character
Sql :: sqlite copy table to another table
Sql :: check if word is in column sql
Sql :: mysql sql select one day before
Sql :: phone number regex sql
Sql :: delete table row in postgresql
Sql :: generate sql from specific migration ef core
Sql :: PostgreSQL: To_Number function
Sql :: oracle lock user
Sql :: sql dcl
Sql :: copy a table mysql
Sql :: sqrt(i)
Sql :: BigQuery Remove Duplicate Keys From Table
Sql :: Oracle filter date column by year
Sql :: sql table backup
Sql :: How to check if a column exists in a SQL Server table?
Sql :: group_concat mysql
Sql :: sql add calculated column
Sql :: stored procedure sql
Sql :: SQL/update
Sql :: postgresql find blocked query
Sql :: delete and drop in sql
Sql :: mysqli_free_result
Sql :: insufficient privileges while creating view in sql oracle

Search

SQL

How to find string in substring in sql server

ADD CONTENT