UnicodeAfter (Unicode function) - Revision history

JAL: /* Examples */ drop second example

2016-06-03T17:10:55Z

Examples: drop second example

@@ Line 33: / Line 33: @@
 ==Examples==
-In the following requests, the given initial string is "Manos: The Hands of Fate [is a D-minus] of a B movie". The substring that follows the left square bracket (<tt>[</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model&nbsp;204.
+In the following request, the given initial string is "Manos: The Hands of Fate [is a D-minus] of a B movie". The substring that follows the left square bracket (<tt>[</tt>) character representation is excerpted by <var>UnicodeAfter</var>. The request uses an [[Release notes for Model 204 version 7.6#New XHTML entities for square-bracket characters|enhancement for square-bracket handling]] introduced in version 7.6 of Model&nbsp;204.
 <p class="code">begin
 %x is unicode
@@ Line 52: / Line 42: @@
 <p>
 The result is:</p>
-<p class="output">is a D-minus] of a B movie</p></li>
+<p class="output">is a D-minus] of a B movie</p>
 ==See also==
 {{Template:Unicode:UnicodeAfter footer}}

JAL: /* Examples */ multiple tweaks

2016-06-01T23:06:23Z

Examples: multiple tweaks

← Older revision		Revision as of 23:06, 1 June 2016
Line 58:		Line 58:
	The left and right square brackets below are created using the <var>U</var> method and placed in variables <code>%lsq</code> and <code>%rsq</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>		The left and right square brackets below are created using the <var>U</var> method and placed in variables <code>%lsq</code> and <code>%rsq</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>
	<p class="code">begin		<p class="code">begin
	%lsq is string len 1 initial("&#x5B;"<b>:U</b>) static		%lsq is string len 1 initial('&#x5B;'<b>:U</b>) static
	%rsq is string len 1 initial("&#x5D;"<b>:U</b>) static		%rsq is string len 1 initial('&#x5D;'<b>:U</b>) static
	%x is unicode		%x is unicode
	%x = 'Manos: The Hands of Fate ' with %lsq with -		%x = 'Manos: The Hands of Fate ' with %lsq with -

JAL: /* Examples */ multiple tweaks

2016-06-01T18:01:09Z

Examples: multiple tweaks

← Older revision		Revision as of 18:01, 1 June 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	In the following requests, the given initial string is "Manos: The Hands of Fate [is a D-minus] of a B movie". The substring that follows the ~~right~~ square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.		In the following requests, the given initial string is "Manos: The Hands of Fate [is a D-minus] of a B movie". The substring that follows the left square bracket (<tt>[</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.
	<ul>		<ul>
	<li>For version 7.6 and higher:		<li>For version 7.6 and higher:
	<p>		<p>
	The left and right square brackets used in this example are created using the [[U (String function)\|U constant function]] with the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because~~, depending~~ on your PC's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>		The left and right square brackets used in this example are created using the [[U (String function)\|U constant function]] with the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because: </p>
			<ul>
			<li>They are slightly more efficient than the %variable-assignment approach shown in the version 7.5 example below. </li>

			<li>Depending on your PC's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]. </li>
			</ul>

	<p class="code">begin		<p class="code">begin
	%x is unicode		%x is unicode
	%x = 'Manos: The Hands of Fate <b>[</b>is a D-minus<b>]</b> '<b>:U</b> 'of a B movie'		%x = 'Manos: The Hands of Fate <b>[</b>is a D-minus<b>]</b> '<b>:U</b> 'of a B movie'
	~~print '%x is: ' %x~~		printText {%x:unicodeAfter('['<b>:U</b>)}
	printText {%x:unicodeAfter('&~~rsqb~~;')}
	end		end
	</p>		</p>
	<p>		<p>
	The ~~first line of output shows the effect of the <var>U</var> method and XHTML entities. The second line shows the substring returned by <var>UnicodeAfter</var>~~:</p>		The result is:</p>
	<p class="output">~~%x is: Manos: The Hands of Fate [~~is a D-minus] ~~of a B movie~~		<p class="output">is a D-minus] of a B movie</p></li>
	of a B movie</p></li>

	<li>For version 7.5:		<li>For version 7.5:
	<p>		<p>
	The left and right square brackets below are created using the <var>[[U ~~(String function)\|U]]~~</var> method and placed in variables <code>%lsq</code> and <code>%rsq</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>		The left and right square brackets below are created using the <var>U</var> method and placed in variables <code>%lsq</code> and <code>%rsq</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>
	<p class="code">begin		<p class="code">begin
	%~~sqL~~ is string len 1 initial("&#x5B;":U) static		%lsq is string len 1 initial("&#x5B;"<b>:U</b>) static
	%~~sqR~~ is string len 1 initial("&#x5D;":U) static		%rsq is string len 1 initial("&#x5D;"<b>:U</b>) static
	%x is unicode		%x is unicode
	~~print '%x is: ' %x~~
	%x = 'Manos: The Hands of Fate ' with %lsq with -		%x = 'Manos: The Hands of Fate ' with %lsq with -
	'is a D-minus' with %rsq with ' of a B movie'		'is a D-minus' with %rsq with ' of a B movie'
	printText {%x:unicodeAfter(%~~rsq~~)}		printText {%x:unicodeAfter(%lsq)}
	end		end
	</p>		</p>
	<p>		<p>
	Again, the request result is:</p>		Again, the request result is:</p>
	<p class="output">~~%x is: Manos: The Hands of Fate [~~is a D-minus] ~~of a B movie~~		<p class="output">is a D-minus] of a B movie</p></li>
	of a B movie</p></li>
	</ul>		</ul>

	==See also==		==See also==
	{{Template:Unicode:UnicodeAfter footer}}		{{Template:Unicode:UnicodeAfter footer}}

JAL: /* Examples */ multiple tweaks

2016-06-01T01:32:41Z

Examples: multiple tweaks

← Older revision		Revision as of 01:32, 1 June 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	In the following requests, the substring that follows the right square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.		In the following requests, the given initial string is "Manos: The Hands of Fate [is a D-minus] of a B movie". The substring that follows the right square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.
	<ul>		<ul>
	<li>For version 7.6 and higher:		<li>For version 7.6 and higher:
	<p>		<p>
	The left and right square brackets used in this example are created using the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because, depending on your PC's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>		The left and right square brackets used in this example are created using the [[U (String function)\|U constant function]] with the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because, depending on your PC's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>
	<p class="code">begin		<p class="code">begin
	%x is unicode		%x is unicode
	%x = '~~Released in 1966,~~ Manos: The Hands of Fate [is a D-minus] ' -		%x = 'Manos: The Hands of Fate <b>[</b>is a D-minus<b>]</b> '<b>:U</b> 'of a B movie'
	'of a B movie: ~~Its plot, about desert-dwelling pagans, makes little sense.~~'		print '%x is: ' %x
	printText {%x:unicodeAfter(']')}		printText {%x:unicodeAfter(']')}
	end		end
	</p>		</p>
	<p>		<p>
	The ~~request result is~~:</p>		The first line of output shows the effect of the <var>U</var> method and XHTML entities. The second line shows the substring returned by <var>UnicodeAfter</var>:</p>
	<p class="output"> of a B movie~~: Its plot, about desert-dwelling pagans, makes little sense.~~</p></li>		<p class="output">%x is: Manos: The Hands of Fate [is a D-minus] of a B movie
			of a B movie</p></li>

	<li>For version 7.5:		<li>For version 7.5:
	<p>		<p>
	The left and right square brackets below are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%~~sqL~~</code> and <code>%~~sqR~~</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>		The left and right square brackets below are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%lsq</code> and <code>%rsq</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>
	<p class="code">begin		<p class="code">begin
	%sqL is string len 1 initial("[":u) static		%sqL is string len 1 initial("&#x5B;":U) static
	%sqR is string len 1 initial("]":u) static		%sqR is string len 1 initial("&#x5D;":U) static
	%x is unicode		%x is unicode
	%x = '~~Released in 1966,~~ Manos: The Hands of Fate ' with %~~sqL~~ with -		print '%x is: ' %x
	' is a D-minus ' with %~~sqr~~ with -		%x = 'Manos: The Hands of Fate ' with %lsq with -
	' of a B movie~~: Its plot, about desert-dwelling pagans, makes little sense.~~'		'is a D-minus' with %rsq with ' of a B movie'
	printText {%x:unicodeAfter(%~~sqR~~)}		printText {%x:unicodeAfter(%rsq)}
	end		end
	</p>		</p>
	<p>		<p>
	Again, the request result is:</p>		Again, the request result is:</p>
	<p class="output"> of a B movie~~: Its plot, about desert-dwelling pagans, makes little sense.~~</p></li>		<p class="output">%x is: Manos: The Hands of Fate [is a D-minus] of a B movie
			of a B movie</p></li>
	</ul>		</ul>

	==See also==		==See also==
	{{Template:Unicode:UnicodeAfter footer}}		{{Template:Unicode:UnicodeAfter footer}}

JAL: /* Examples */ remove with

2016-05-31T23:30:05Z

Examples: remove with

← Older revision		Revision as of 23:30, 31 May 2016
Line 40:		Line 40:
	<p class="code">begin		<p class="code">begin
	%x is unicode		%x is unicode
	%x = 'Released in 1966, Manos: The Hands of Fate [is a D-minus] ' ~~with~~ -		%x = 'Released in 1966, Manos: The Hands of Fate [is a D-minus] ' -
	'of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'		'of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'
	printText {%x:unicodeAfter(']')}		printText {%x:unicodeAfter(']')}

JAL: /* Examples */ word change

2016-05-17T22:59:07Z

Examples: word change

← Older revision		Revision as of 22:59, 17 May 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	In the following requests, the substring that follows the right square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.		In the following requests, the substring that follows the right square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.
	<ul>		<ul>
	<li>For version 7.6 and higher:		<li>For version 7.6 and higher:
	<p>		<p>
	The left and right square brackets used in this example are created using the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because, depending on your ~~browser~~'s [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>		The left and right square brackets used in this example are created using the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because, depending on your PC's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>
	<p class="code">begin		<p class="code">begin
	%x is unicode		%x is unicode

JAL: /* Examples */ add new example using new [ & ] entities

2016-05-09T22:35:00Z

Examples: add new example using new [ & ] entities

← Older revision		Revision as of 22:35, 9 May 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	In the following ~~request~~, the ~~left and~~ right square ~~brackets are created using the~~ <var>~~[[U (String function)\|U]]~~</var> ~~method~~ and ~~placed~~ in ~~variables~~ <code>~~%sqL~~</code> and <code>~~%sqR~~</code>. ~~Depending~~ on your browser's [[Unicode#Code points.2C character set mappings\|codepage]], the square ~~brackets~~ may or may not render correctly. The variables are inserted into a <var>Unicode</var> string and used to parse that string:		In the following requests, the substring that follows the right square bracket (<tt>]</tt>) character representation is excerpted by <var>UnicodeAfter</var>. Two variations of the request are shown because of an enhancement for square-bracket handling introduced in version 7.6 of Model 204.
			<ul>
			<li>For version 7.6 and higher:
			<p>
			The left and right square brackets used in this example are created using the <code>[</code> and <code>]</code> XHTML entities, added by zap maintenance in version 7.6. These entities are recommended because, depending on your browser's [[Unicode#Code points.2C character set mappings\|codepage]], the [[Unicode#sqbrackets\|square bracket characters may or may not render correctly]]: </p>
			<p class="code">begin
			%x is unicode
			%x = 'Released in 1966, Manos: The Hands of Fate [is a D-minus] ' with -
			'of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'
			printText {%x:unicodeAfter(']')}
			end
			</p>
			<p>
			The request result is:</p>
			<p class="output"> of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</p></li>

			<li>For version 7.5:
			<p>
			The left and right square brackets below are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%sqL</code> and <code>%sqR</code>. The variables are inserted into a <var>Unicode</var> string and used to parse that string: </p>
	<p class="code">begin		<p class="code">begin
	%sqL is string len 1 initial("[":u) static		%sqL is string len 1 initial("[":u) static
Line 41:		Line 59:
	' is a D-minus ' with %sqr with -		' is a D-minus ' with %sqr with -
	' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'		' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'
	printText {%x:~~unicodeBefore~~(%sqR)}		printText {%x:unicodeAfter(%sqR)}
	end		end
	</p>		</p>
	<p>		<p>
	~~The~~ request result is:</p>		Again, the request result is:</p>
	<p class="output">of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</p>		<p class="output"> of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</p></li>
			</ul>

	==See also==		==See also==
	{{Template:Unicode:UnicodeAfter footer}}		{{Template:Unicode:UnicodeAfter footer}}

JAL: typo

2016-05-07T01:16:40Z

typo

← Older revision		Revision as of 01:16, 7 May 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	In the following request, the left and right square brackets are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%sqL</code> and <code>%sqR</code>. Depending on your browser's [[Unicode#Code points.2C character set mappings\|codepage]], the square brackets may or may not render correctly. The variables are inserted into a <var>Unicode</var> string and used to parse that string:		In the following request, the left and right square brackets are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%sqL</code> and <code>%sqR</code>. Depending on your browser's [[Unicode#Code points.2C character set mappings\|codepage]], the square brackets may or may not render correctly. The variables are inserted into a <var>Unicode</var> string and used to parse that string:
	<p class="code">begin		<p class="code">begin
	%sqL is string len 1 initial("[":u) static		%sqL is string len 1 initial("[":u) static
	%sqR is string len 1 initial("]":u) static		%sqR is string len 1 initial("]":u) static
	%x is unicode		%x is unicode
	%x = 'Released in 1966, Manos: The Hands of Fate ' with %~~sql~~ with -		%x = 'Released in 1966, Manos: The Hands of Fate ' with %sqL with -
	' is a D-minus ' with %sqr with -		' is a D-minus ' with %sqr with -
	' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'		' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'

JAL: add link

2016-05-07T00:25:36Z

add link

← Older revision		Revision as of 00:25, 7 May 2016
Line 33:		Line 33:

	==Examples==		==Examples==
	~~The~~ following request the left and right square brackets are created using the ~~unicode~~ method and placed in variables %sqL and %sqR. Depending on your browser's codepage, the square brackets may or may not render correctly. ~~They~~ are ~~then~~ inserted into a ~~unicode~~ string and used to parse that string:		In the following request, the left and right square brackets are created using the <var>[[U (String function)\|U]]</var> method and placed in variables <code>%sqL</code> and <code>%sqR</code>. Depending on your browser's [[Unicode#Code points.2C character set mappings\|codepage]], the square brackets may or may not render correctly. The variables are inserted into a <var>Unicode</var> string and used to parse that string:
	~~<p><code>of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</code></p>~~		<p class="code">begin
	<p class="code">begin		%sqL is string len 1 initial("[":u) static
	%sqL is string len 1 initial("[":u) static		%sqR is string len 1 initial("]":u) static
	%sqR is string len 1 initial("]":u) static		%x is unicode
	%x is unicode		%x = 'Released in 1966, Manos: The Hands of Fate ' with %sql with -
	%x = 'Released in 1966, Manos: The Hands of Fate ' with %sql with -		' is a D-minus ' with %sqr with -
	' is a D-minus ' with %sqr with -
	' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'		' of a B movie: Its plot, about desert-dwelling pagans, makes little sense.'
	printText {%x:unicodeBefore(%sqR)}		printText {%x:unicodeBefore(%sqR)}
	end		end
	</p>		</p>
			<p>
			The request result is:</p>
			<p class="output">of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</p>

	==See also==		==See also==
	{{Template:Unicode:UnicodeAfter footer}}		{{Template:Unicode:UnicodeAfter footer}}
	~~The <var>[[UnicodeBefore (Unicode function)\|UnicodeBefore]]</var> string method.~~

JAL: misc cleanup

2016-05-07T00:00:26Z

misc cleanup

← Older revision		Revision as of 00:00, 7 May 2016
Line 1:		Line 1:
	{{Template:Unicode:UnicodeAfter subtitle}}		{{Template:Unicode:UnicodeAfter subtitle}}

	<var>UnicodeAfter</var> operates on a Unicode variable or string and returns the portion of that string after a user-specified delimiter. To get the portion of the string before a delimiter, use the <var>[[UnicodeBefore (Unicode function)\|UnicodeBefore]]</var> ~~string~~ method.		<var>UnicodeAfter</var> operates on a Unicode variable or string and returns the portion of that string after a user-specified delimiter. To get the portion of the string before a delimiter, use the <var>[[UnicodeBefore (Unicode function)\|UnicodeBefore]]</var> method.

	==Syntax==		==Syntax==
	{{Template:Unicode:UnicodeAfter syntax}}		{{Template:Unicode:UnicodeAfter syntax}}

	===Syntax terms===		===Syntax terms===
	<table ~~class="syntaxTable"~~>		<table>
	<tr><th>%~~outString~~</th>		<tr><th>%outUnicode</th>
	<td>A ~~unicode~~ variable to hold the output of the parsed input unicode ~~string~~.</td></tr>		<td>A <var>Unicode</var> variable to hold the output of the parsed input string, <var class="term">unicode</var>.</td></tr>
	<tr><th>~~string~~</th>
	<td>A ~~unicode~~ string that holds the string to be parsed.</td></tr>		<tr><th>unicode</th>
			<td>A <var>Unicode</var> string that holds the string to be parsed.</td></tr>

	<tr><th>substring</th>		<tr><th>substring</th>
	<td>A ~~unicode~~ string that holds the separator character or characters on which parsing occurs.</td></tr>		<td>A <var>Unicode</var> string that holds the separator character or characters on which parsing occurs.</td></tr>

	<tr><th><var>Start</var></th>		<tr><th><var>Start</var></th>
	<td>~~number: The~~ starting point for parsing. The default value is 1, indicating the beginning of the string. This is a name~~-optional~~ argument and cannot be 0. If a value larger than the string is specified, the method ~~always~~ returns a null string.</td></tr>		<td>This numeric value is the starting point for parsing. The default value is 1, indicating the beginning of the string.
			<p>
			This is a [[Notation conventions for methods#Named arguments\|name required]] argument, and it cannot be 0. If a value larger than the string length is specified, the method returns a null string. </p></td></tr>
	</table>		</table>

	==Usage notes==		==Usage notes==
	If a starting value is entered, the %~~outString~~ is the content of the string ~~beginning~~ after the first occurrence of the delimiter ~~string~~ encountered after the specified start point, and ~~ending~~ at the end of the string.		<ul>
	The delimiter string is not a list of individual delimiters~~, but~~ a single delimiter which may be multiple characters. ~~In other words, if~~ your delimiter is 'ok', the method looks for occurrences of those two ~~lower-case~~ letters and returns a value after ~~said~~ occurrence,		<li>If a starting value is entered, the <var class="term">%outUnicode</var> value is the content of the string that begins after the first occurrence of the delimiter substring encountered after the specified start point, and that ends at the end of the string.
	This method is always case-sensitive.		<p>
			The delimiter string is not a list of individual delimiters; it is a single delimiter which may be multiple characters. If your delimiter is "ok", the method looks for occurrences of those two lowercase letters, and it returns a value that starts after the first occurrence found after the starting point. </p></li>

			<li>This method is always case-sensitive. </li>
			</ul>

	==Examples==		==Examples==

	The following request the left and right square brackets are created using the unicode method and placed in variables %sqL and %sqR. Depending on your browser's codepage, the square brackets may or may not render correctly. They are then inserted into a unicode string and used to parse that string:		The following request the left and right square brackets are created using the unicode method and placed in variables %sqL and %sqR. Depending on your browser's codepage, the square brackets may or may not render correctly. They are then inserted into a unicode string and used to parse that string:
	<p><code>of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</code></p>		<p><code>of a B movie: Its plot, about desert-dwelling pagans, makes little sense.</code></p>
	<p class="code">begin		<p class="code">begin
	%sqL is string len 1 initial("[":u) static		%sqL is string len 1 initial("[":u) static
	%sqR is string len 1 initial("]":u) static		%sqR is string len 1 initial("]":u) static
	%x is unicode		%x is unicode
	%x = 'Released in 1966, Manos: The Hands of Fate ' with %sql with -		%x = 'Released in 1966, Manos: The Hands of Fate ' with %sql with -