Search results for query: *

Hi everybody... I have a name field here and want to get rid of the "O'donnels". Can someone tell me the syntax for searching a column for a tick mark? thanks

I have Toad and SQL Nav here. We just moved an instance of a database from one server to another. I changed my TNS Names files, however, I cannot connect to the new instance via TOAD or SQL Nav. I can connect with SQL PLUS, which tells me that my TNS Names file is ok and the DB is ok. I...

I apologize for asking this question, i'm sure it's already been addressed in here at some point, but a search didn't turn up much. Can someone tell me what the fundamental difference between VBA and VB is? Why didn't Microsoft just embed regular VB into it's apps? Thanks

I have never used DB2 or an AS/400. We have one on our network now and need to do data exports from it, for other systems. Can anyone point me to some sort of client tool to connect, and export data from the DB2 database? thanks

Hi all... I'm fairly new to Oracle and am experiencing extreme problems with users locking records and blocking out others. Our software vendor has suggested we run the ANALYZE (compute statistics) and this will fix our blocking locks. Does anyone see a correlation here? We have run it, and...

I'm fairly new to Oracle. Can I put an "if" statement within my "select" statement to determine what value i'm returning? for example: select field 1, field 2, field 3, if field 4 in (select field 1 from TABLE 2) (here I want to return string...

This is my first day using Delphi. I was wondering if anyone knows some good resources for very basic things. What is Delphi? What is it used for? Can it be used over the web? And more specifically, how do I change data types? Thanks

I have a loop of code that i'm running where I clear out variables, then set them equal to a value, then update my recordset...pretty standard. When you clear a string variable, I just set it equal to empty string "". How do I clear out a variable of datatype date? I want to set it...

Easy one for everyone, I should know this answer but am having a brainfart. I have a variable called startdate. It gets set in a vba loop. At the beginning of the loop, I clear out my variables from the previous record, and set them again, then update my recordset. If it were a string, I...

I have a query here that seems as though it should work, but I know I have to do some funky parentheses in Access or something to get joins to work correctly. I have several nested left joins and Access does not like my syntax....any suggestions? SELECT CLASSES.ID FROM CLASSES left JOIN...

I am new at PL/SQL and have some basic syntactical questions. Can anyone point me to a good web reference? I apologize if this is not the correct forum for this, I can't seem to find another one more fitting? One question I had is, how do I select the leftmost N characters of a field? For...

Can anyone tell me what this error means? "Reserved Error (-3022); There is no message for this error" Microsoft knowledgebase has 0 articles. I am not doing any connecting to other databases or anything, it's merely an insert query, from one table in my database to another, the...

I have several tables here that are ALMOST identical in structure. I've got vba code and queries that need to work for all of these tables. The problem is that there must be a few fields that are different between the tables. There are so many fields in these tables that it's almost...

I have a field here that used to be a number. I recently changed it to text. The ENTIRE column has a value of "1". When I export this table, this text column exports as "1.00". Has anyone encountered this or does anyone know how to fix it?

I am matching two fields that have the same string, only the cases are very different. For example, I need "IlInOiS" to match to "Illinois" and "ILLINOIS". I know of the ucase() and lcase(), but is there a function that would allow me to ignore case altogether, or...

I have 25 tables that are identical in structure. I need a query that can add the same field with different data to all of them. More specifically, each table represents demographic information of thousands of students. I need to put all of this data together into one table, that part is...

I apologize if this is not the correct forum for this question. Anyway, does anyone know of a really good tool to convert entire databases? I want to convert a huge Oracle database with scripts and everything to SQL Server 2000. I have found plenty of tools to move data, but none that really...

I have dates here stored as mm/dd/yyyy. I will be exporting them into a fixed width file. I put a format on the table to change them to mmddyyyy. When I open the table the dates appear just as I need them for exporting, with no slashes. When I query this table, the query results show up...

I have in a field here your normal "LastName, FirstName". I need to make a query that takes the firstname and lastname and separate them in new fields called 'FirstName' and 'LastName'. Does anyone have handy a query that will separate a string like this? Thanks

I have a query that requires brackets ([]) around it. I have a field name ( not my doing, I promise) that has several spaces in it and the field needs to be refered to with brackets. When I use brackets within an already bracketed query, I get an error that says 'invalid bracketing'. Does...