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!
Recent content by 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'...- louiethebrain
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
