Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: futbwal15
  • Order by date
  1. futbwal15

    multiple parse????

    thanks george
  2. futbwal15

    multiple parse????

    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
  3. futbwal15

    multiple parse????

    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(' '...
  4. futbwal15

    multiple parse????

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

    multiple parse????

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

    multiple parse????

    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...
  7. futbwal15

    multiple parse????

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

    multiple parse????

    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"...
  9. futbwal15

    multiple parse????

    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?
  10. futbwal15

    sql parse possible?

    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?
  11. futbwal15

    sql parse possible?

    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...
  12. futbwal15

    mortgage calculator

    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...
  13. futbwal15

    computer randomly shuts off

    how do i run event viewer?
  14. futbwal15

    computer randomly shuts off

    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?
  15. futbwal15

    ajax features?

    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.
  16. futbwal15

    IE7 problems with google

    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?
  17. futbwal15

    update and insert help

    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?
  18. futbwal15

    update and insert help

    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...
  19. futbwal15

    update and insert help

    syntax errors seem to be the problem as of now
  20. futbwal15

    update and insert help

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

Part and Inventory Search

Back
Top