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

    Zero Length Double Type Problem and datetime problem

    After upgrading from 4.0.16 to 4.0.18 any field that had a zero length has been destroyed. Specifically I had some double fields that had "4" and now have "2.055313086699586e-320". I also had some some datetime fields that have 0 length that now have "0000-00-00 00:00:00" where there were...
  2. JStevison

    IN Operator question

    Why does this not work? select * from Menus where 'g' IN (Menus.menuSecurity) Explanation: Menus.menuSecurity contains an nvarchar field with this data - a,b,c,d,e,f,g,h I get 0 results. If I remove everything except the letter g I get a result of 1 record as expected.

Part and Inventory Search

Back
Top