tuzojazz
-
Posts
12 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by tuzojazz
-
-
string length
in SQL
Hi:suppose I have this tableCUSTOMERS---------------------Name---------------------JohnGabrielGeorgeKenI need to make a query to get customers where the Name length is equal or greater than 6Name--------------------GabrielGeorgeHow Can I make this query or/and where can I find information about this kind of query?Thanks!!
-
nz function
in SQL
Hi:I'm programming an aspx in visual basic.net code in notepad.From my aspx I'm trying to make a query to a database that is in access but I get aSystem.Data.OleDb.OleDbException saying Nz function is not defined.The query is something like thisSELECT Nz(SUM(Total),0)FROM CargoDWHERE Folio=4224When I try the query in access it works but from my aspx not.What could be wrong?What can I do?Thanks!
-
-
between dates
in SQL
Hi:I have a table named "Calls"Calls----------------------------Id Date----------------------------2 04/04/2006 11:33:073 04/04/2006 11:35:27-----------------------------Both records have the same date but different timeWhen I make this query I don't get records-------------------------------------------------SELECT Id, Date FROM CallsWHERE Date BETWEEN #4/4/2006# AND #4/4/2006#-------------------------------------------------Why I don't get records If all records in table "Calls" have 04/04/2006 on column "Date"?Thanks!
-
HiI have two tables: Employees_Norway and Employees_USAEmployees_Norway:Employee_ID E_Name-------------------------------01 Hansen, Ola 02 Svendson, Tove 03 Svendson, Stephen 04 Pettersen, Kari Employees_USA:Employee_ID E_Name------------------------------01 Turner, Sally 02 Kent, Clark 03 Svendson, Stephen 04 Scott, Stephen In order to list all employees in Norway and USA I'm using this query:------------------------------------------------SELECT E_Name FROM Employees_NorwayUNION ALLSELECT E_Name FROM Employees_USA------------------------------------------------I get this resultName ----------------------Hansen, Ola Svendson, Tove Svendson, Stephen Pettersen, Kari Turner, Sally Kent, Clark Svendson, Stephen Scott, Stephen What more does need my query to get the result in alphabetical order?Thanks!!
string length
in SQL
Posted
Hi:Thanks but char_length does not work in access.Is there a function that works in access?