Extracting substrings - Revision history

Connor at 14:32, 17 July 2012

2012-07-17T14:32:47Z

Connor at 14:29, 17 July 2012

2012-07-17T14:29:28Z

Connor at 14:27, 17 July 2012

2012-07-17T14:27:49Z

Connor: Created page with "Substring: Extracting part of a string.

schema:gisq

We from position 1 (the beginning) we take two characters. 4. 'Afghanistan'..."

2012-07-17T14:25:03Z

Created page with "Substring: Extracting part of a string. <div class='ht'> <div class=params>schema:gisq</div> <div> We from position 1 (the beginning) we take two characters. 4. 'Afghanistan'..."

New page

Substring: Extracting part of a string.
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
We from position 1 (the beginning) we take two characters. 4.
'Afghanistan' -> 'Af'
'China' -> 'Ch'
'Sri Lanka' -> 'Sr'
The SQL standard insists on a horrible syntax:
SUBSTRING(name FROM 1 FOR 2)
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-sqlite'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-db2'>SELECT name, SUBSTR(name,1,2) FROM bbc</source>
<source lang='sql' class='def e-ingres'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-access'>SELECT name, MID(name,1,2) FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-postgres'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-oracle'>SELECT name, SUBSTR(name,1,2) FROM bbc</source>
<source lang='sql' class='def e-sqlserver'>SELECT name, SUBSTRING(name ,1 ,2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-mysql'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-mimer'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
FROM bbc
WHERE region = 'Asia'</source>
<source lang='sql' class='def e-sybase'>SELECT name, SUBSTRING(name ,1 ,2)
FROM bbc
WHERE region = 'Asia'</source>

<div class="ecomm e-access" style="display: none">Access betrays it's BASIC ancestry. LEFT and RIGHT are also available</div>
<div class="ecomm e-oracle" style="display: none">See also SUBSTR
SELECT name, SUBSTR(name,1,2)
FROM cia
WHERE region = 'Asia'</div>
</div>
{{Functions ref}}

@@ Line 30: / Line 30: @@
   WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-mysql'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM bbc
+  FROM bbc</source>
- WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-mimer'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
   FROM bbc

@@ Line 14: / Line 14: @@
 <source lang=sql class='setup'></source>
 <source lang='sql' class='def e-sqlite'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
-<source lang='sql' class='def e-db2'>SELECT name, SUBSTR(name,1,2) FROM cia</source>
+<source lang='sql' class='def e-db2'>SELECT name, SUBSTR(name,1,2) FROM bbc</source>
 <source lang='sql' class='def e-ingres'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
-<source lang='sql' class='def e-access'>SELECT name, MID(name,1,2) FROM cia
+<source lang='sql' class='def e-access'>SELECT name, MID(name,1,2) FROM bbc
   WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-postgres'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
-<source lang='sql' class='def e-oracle'>SELECT name, SUBSTR(name,1,2) FROM cia</source>
+<source lang='sql' class='def e-oracle'>SELECT name, SUBSTR(name,1,2) FROM bbc</source>
 <source lang='sql' class='def e-sqlserver'>SELECT name, SUBSTRING(name ,1 ,2)
   FROM cia
   WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-mysql'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-mimer'>SELECT name, SUBSTRING(name FROM 1 FOR 2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
 <source lang='sql' class='def e-sybase'>SELECT name, SUBSTRING(name ,1 ,2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</source>
@@ Line 42: / Line 42: @@
 <div class="ecomm e-oracle" style="display: none">See also SUBSTR
   SELECT name, SUBSTR(name,1,2)
-  FROM cia
+  FROM bbc
   WHERE region = 'Asia'</div>
 </div>
 {{Functions ref}}

Extracting substrings - Revision history

Connor at 14:32, 17 July 2012

Connor at 14:29, 17 July 2012

Connor at 14:27, 17 July 2012

Connor: Created page with "Substring: Extracting part of a string. schema:gisq We from position 1 (the beginning) we take two characters. 4. 'Afghanistan'..."

Connor: Created page with "Substring: Extracting part of a string.

schema:gisq

We from position 1 (the beginning) we take two characters. 4. 'Afghanistan'..."