| |
| |
| |
|
Comments:
<0> I have a field with a binary string such as '10010100' I want to return all rows that have a 1 in the 4th position from the left. Is it possible with a query or would I have to work it out in the business layer? mssql 2005
<1> SELECT * FROM MyTable WHERE Substring(myField, 1, 4) = '1' blah?
<1> Narbs:: owned
<0> ah substring.. I was thinking to use LIKE
<1> Narbs:: screw you man!
<1> i am goign home!
<2> emergency users death imminent
<3> ?
<4> tomorrow would be a great geocaching day. to bad i have to goto a wedding
<2> what did i do ?
<5> werd
<6> in MySQL.. GROUP_CONCAT(DISTINCT levert) <-- that groups all distinct fields of levert (after its grouped), but if levert-1 is 'blah' and levert=2 is '' or empty, then it still groups them
<6> as they are DISTINCT.......
<6> how do i tell it to not GROUP_CONCAT if a field is empty
<6> i get now results like ',blah,'
<7> i have 2 tables that contains logs. they have the same fields, how do i select all records from both?
<7> hello??
<7> r u there ppl???
<8> i am
<9> MainProc:: just say the magic word.
<9> what's your RDBMS
<9> MainProc:: you are no fun
<9> just use "UNION"
<9> or "UNION ALL" whichever one suits you
<10> What port does an access front-end connect to a MSSQL2000 backend
<10> or ports (plural)
<11> 1433 or 1344 or something like that
<11> 1433
<11> final answer
<11> do i have any lifelines left?
<3> 1433, you win
<12> if i wish to add date using C# front end to the database what shud be the sytanx im using isql plus
<3> to_date('02-MAR-2006','DD-MON-YYYY')
<13> http://www.flickr.com/photos/theofpa/167011569/
<14> How do I scramebel my rows in a SELECt statement in sql2005?
<3> scramebel ?
<14> I have a tabel with some values in order and I don't want em to be in an order (ir disOrder By ;))
<15> i'm using Access database, having trouble with this query: http://pastebin.com/715014 in specific the having clause
<15> if i specify for instance, < 5, the result set still shows records above 5
<15> it shows all records actually
<16> capitanlB: Try ordering by newid()
<17> evening
Return to
#sql
or
Go to some related
logs:
The idustrial revolution
#computers
prebot sql eggdrop
afghanistan haubitze 2000
#3dsmax
#computers
Application.Info.Version.Build incorrect
#mirc
#beginner
#nhl
|
|