charindex sql code example

Example 1: locate sql server

SELECT CHARINDEX('b','ab') //returns 2

Example 2: sql selet

SELECT *
FROM table
WHERE condition
GROUP BY expression
HAVING condition
{ UNION | INTERSECT | EXCEPT }
ORDER BY expression
LIMIT count
OFFSET start

Example 3: charindex

DECLARE @document VARCHAR(64);  
SELECT @document = 'Reflectors are vital safety' +  
                   ' components of your bicycle.';  
SELECT CHARINDEX('bicycle', @document);  
GO

Example 4: st_buffer mysql

ST_Buffer(g, d[, strategy1[, strategy2[, strategy3]]])

Tags:

Misc Example

Related