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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL queries by data type.
I do believe that would have worked. However, we found a fix that is working now (and if it ain't broke, don't fix it). If anyone else stumbles across this and is curious, here's the fix: SELECT * FROM Modules WHERE ItemID = 123 AND SubItemContent cast (cast (SubItemContent as nvarchar) as...- Brasil221
- Post #5
- Forum: Data Warehousing/Big Data
-
SQL queries by data type.
There is a glimmer of hope... The dates are selected from a calendar by the user, rather than input into a textbox, so they're all uniformly in a "DD/MM/YYYY" format. I tried querying SubItemContent LIKE "%/%/%" but it still wouldn't let me ODER BY SubItemContent, stating that "The text, ntext...- Brasil221
- Post #3
- Forum: Data Warehousing/Big Data
-
SQL queries by data type.
I am currently developing a webpage in ASP using a lot of ADO, and therefore, SQL. This would be all fine and dandy, if it weren't for the insanely convoluted database system we have at my workplace. --Skip this part if you don't want the backstory-- You see, my boss came up with this...- Brasil221
- Thread
- Replies: 4
- Forum: Data Warehousing/Big Data
