Search results for query: *

thanks george

now the only problem is that if data runs through that reads 2003 Pontiac Grand Am........i get 2003 in a column.....Pontiac Grand in a column, and then Am in a column in stead of 2003,pontiac, grand am

replace f.custom1 with convert(varchar(500),f.custom1) replace l.itemtext with convert(varchar(500),l.itemtext) select f.matteridstring,f.custom1, Substring(l.itemtext, 12, 2) As "Year", Left(f.custom1, CharIndex(' ', f.custom1)), Replace(Replace(f.custom1, Left(f.custom1, CharIndex(' '...

yes Msg 8116, Level 16, State 1, Line 1 Argument data type text is invalid for argument 1 of left function.

not the case, just confused because i keep getting errors.

this is the code i already have: select f.matteridstring, f.custom1, Substring(l.itemtext, 12, 2) As itemtext from contacts c, parties p, fileinfo f, listbox l where l.itemtext like 'Lemon Law%' and c.contactid = p.contactid and f.fileno = p.fileno and f.filetype = l.id now when i run my...

how would i implement this into the code i already have? i dont need the insert values commands

data will look like this: 2000 Ford Mustang 1999 Harley Davidson SE1224 2005 chevrolet cobalt 2001 Mazda 6 and the end result i want is for 3 columns to be created titled Year (where the year will be displayed), Manufacturer (where "ford" for example will be, and then Make (where "mustang"...

say i have a field that lists car year, car manufacturer, and car model.....is it possible to parse this into 3 different outputs? considering they will be different lengths?

substring worked great, thanks earthwind.....now i have another question....say i have a field that lists car year, car manufacturer, and car model.....is it possible to parse this into 3 different parts considering they will be different lengths at all times?

here is my code so far: select f.matteridstring, f.custom1, l.itemtext from contacts c, parties p, fileinfo f, listbox l where l.itemtext like 'Lemon Law%' and c.contactid = p.contactid and f.fileno = p.fileno and f.filetype = l.id when i run the query i get 3 columns....in the last column i...

i need some major help here please. i need to create a mortgage calculator in excel when the user inputs the value of the mortgage, annual rate, loan duration, balloon payment, and number of pay periods a year. then i need to calculate the total payment of the mortgage. any ideas here?????? be...

how do i run event viewer?

im trying to help fix my friends computer, but i dont even know where to start. All she tells me is that the computer is shutting down randomly. So she starts it back up, and it will run normally, but then it will shut back off in 5 minutes or so. Any suggestions?

does anyone know why microsoft came out with .net 3.0.....what does it even do exactly? i was wondering becuase it recently was released along with some new ajax features i saw on the web whil browsing.

im having problems with my IE 7. we run google desktop no problem however though. IE 7 was uninstalled, then reinstalled, but no go...we had to put IE6 back on the computer. any ideas here?

the code works now, however it is not providing me with the task i wanted...it returns 0 rows after execution....if i delete a record from my table and run the query again, it should return 1 row. any ideas?

INSERT INTO "ripedata_old_2" (matteridstring) select distinct (case when c.contactid = p.contactid and f.fileno = p.fileno and f.filetype = l.id and e.fileno = f.fileno and f.isactive = 1 and e.title like '%Converted to LL%' and e.date >= '01/21/2004' and f.matteridstring is not null...

syntax errors seem to be the problem as of now

im not quite sure how to implement it with what i had code wise.