Languages
FsharpActionScript
xBase
Clean
GPSS
PureBasic
Sieve
Erlang
JOVIAL
Mercury
Linda
DataFlex
PostScript
FoxPro2
VFP
Cobol
Prolog
Jython
Awk
VisualBasic
JavaScript
Matlab
ASP
Haskell
Csharp
D
Smalltalk
Nemerle
Pixilang
Java
SQL
Python
ObjectPascal
Ruby
Perl
Pascal
Assembler
PHP
C
| Functions | Add function | Users Registration | Enter | About | ASCII Table | Our helpers |
like in SQL |
|
SQL Like Example One - Like with %
Q: What Godfather Movies have been made? Select Film_Title From Film_Table Where Film_Title like "The Godfather%"; The Godfather The Godfather Part II The Godfather Part III Note: Using the % with Like is a "wildcard" for from none to any number of characters. The % can go anywhere in quotes, and you can even have more than one %. Microsoft Access older version users please note: Some older versions of Microsoft Access use an * instead of a %, and a ? for it's _. The previous example would be as follows for older version MS Access Users: Select Film_Title From Film_Table Where Film_Title like "The Godfather*"; SQL Like Example #2 - Like with _ Q: Is it Francis Ford Coppala or Francis Ford Coppola? Select Director_Last_Name From Director_Table Where Director_Last_Name like "Copp_la"; Coppola Note: The _ is a wildcard for any single character. It can not represent a null. The _ can go anywhere in quotes, and you can even have more than one _. You can even mix _ and %. Microsoft Access older version users please note:: Older versions of Microsoft Access use an * instead of a %, and a ? for it's _. The previous example would be as follows for older version MS Access Users: Select Director_Last_Name From Director_Table Where Director_Last_Name like "Copp?la"; Add by Pancho You can edit it here |
|
abcarticle.ru (blockart[dog]mail[dot]ru) 8nCSVo <a href="http://ouqkogwtmtwm.com/">ouqkogwtmtwm</a>, [url=http://yfjbehxmzqvq.com/]yfjbehxmzqvq[/url], [link=http://pfulphfjxghs.com/]pfulphfjxghs[/link], http://yshsigowuptb.com/ |
|
abcarticle.ru (blockart[dog]mail[dot]ru) 3TnVRR <a href="http://kzjvndltkxcb.com/">kzjvndltkxcb</a>, [url=http://vyiuudtwkvps.com/]vyiuudtwkvps[/url], [link=http://qjureycuobkp.com/]qjureycuobkp[/link], http://ywyeoymdbrcx.com/ |
| Adding comments is available only for registered users. |
| Green Bank Telescope Enables "Intensity Mapping" to Shed Light on Mysteries of Dark Energy
Using the world's largest, fully steerable radio telescope--the National Science Foundation's Robert C. Byrd Green Bank Telescope (GBT) in W.Va.--an international team of researchers has given astronomers the promise of a new tool for mapping the universe and gaining valuable clues about the nature of the mysterious "dark energy" believed to constitute nearly three-fourths of the universe's mass and energy. "Intensity Mapping" offers the potential for ...
|
PycckaR
BepcuR
Articles
Library
Downloads
