Connor: Created page with "Finding a substring in a string

schema:gisq

Here we extract the first word of a country name. INSTR gives this position of one ..."

2012-07-17T14:42:51Z

Created page with "Finding a substring in a string <div class='ht'> <div class=params>schema:gisq</div> <div> Here we extract the first word of a country name. INSTR gives this position of one ..."

New page

Finding a substring in a string
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
Here we extract the first word of a country name.
INSTR gives this position of one string within another, we use this and substring to pick out the first few characters.
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-db2'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-ingres'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-access'>SELECT name,
INSTR(name, ' '),
SUBSTRING(name,1,INSTR(name,' '))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-postgres'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-oracle'>SELECT name,
INSTR(name, ' '),
SUBSTR(name,1,INSTR(name,' '))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-sqlserver'>SELECT name,
CHARINDEX(' ',name),
SUBSTRING(name,1,CHARINDEX(' ',name)-1)
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-mysql'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-mimer'>SELECT name,
POSITION(' ' IN name),
SUBSTRING(name FROM 1 FOR POSITION(' ' IN name))
FROM bbc
WHERE name LIKE '% %'</source>
<source lang='sql' class='def e-sybase'>SELECT name,
CHARINDEX(' ',name),
SUBSTRING(name,1,CHARINDEX(' ',name)-1)
FROM bbc
WHERE name LIKE '% %'</source>

<div class="ecomm e-sqlserver" style="display: none">CHARINDEX gives the position, see also PATINDEX</div>
<div class="ecomm e-oracle" style="display: none"></div>
</div>
{{Functions ref}}

Finding a substring in a string - Revision history

Connor: Created page with "Finding a substring in a string schema:gisq Here we extract the first word of a country name. INSTR gives this position of one ..."

Connor: Created page with "Finding a substring in a string

schema:gisq

Here we extract the first word of a country name. INSTR gives this position of one ..."