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!

  • Congratulations strongm 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: *

  1. louiethebrain

    Sub query substring concatenation issue

    Hi I’ve been stumped on how to use the substring In my subqry but i am a little stumped Could someone lend a hand and explain the Err in my ways please.. select tagname, padname = 1, datetime, (select value from analoghistory where tagname = 'tata' + substring(a.tagname, 6, 2) + 'lastpart'...

Part and Inventory Search

Back
Top