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 bkrike 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: JenJohnson
  • Content: Threads
  • Order by date
  1. JenJohnson

    Parse name field into components

    Good Day, All: I have a field called Manager_Name which contains data, some of which looks like this: C. Lennis Koontz,II Theresa Holt Victor T. Murhman Paul A. Graham, Jr. Thomas Murphy Jr. Jon B. Lovelace Jr. David B. Rees III Mary Jo Ochson M. L...
  2. JenJohnson

    Parse name field into components

    Good Day, All: I have a database field called Manager_Name which contains data, some of which looks like this: C. Lennis Koontz,II Theresa Holt Victor T. Murhman Paul A. Graham, Jr. Thomas Murphy Jr. Jon B. Lovelace Jr. David B. Rees III Mary Jo Ochson M. L. Conery Michael A. Del...
  3. JenJohnson

    convert exponential value to string

    I have a table with a float column, and one value in this column is "0.000098940869229982722". When I try to convert this value to a string, I get "9.8940869229982722e-005". I don't want to see the exponential notation, but I do want to see all the decimal places. I tried...
  4. JenJohnson

    Replication Server and TIMESTAMP datatype

    Just found out from my DBAs that timestamp is an unsupported datatype when it comes to replication server. This datatype is part of the primary key of a table that needs to be replicated. We've discussed changing the datatype of the field from timestamp to datetime, but found that datetime was...

Part and Inventory Search

Back
Top