Looks like a proper answer to me, since the other user only commented, without providing an answer - answer. But - @epardee - I'd prefer if you had included the actual code you used. — ypercubeᵀᴹ3 mins ago
@SeanGallardy-Microsoft ASCII always refers to the 7 bit, afaik. Unless someone is making a flub. Yea, he could be referring to cp1252, but that would be an larger assumption than him wanting to know how to convert an hex encoded ascii character, to the character.
then again, if he was referring to cp1252 that would explain a lot. Only microsoft users use that, and they struggle to understand specs/standards, and why they're never compliant. =)
Probably a newb question, but...
I have a table with a VARCHAR field containing numbers 1 through 300. I need to place a leading zero in front of any numbers less than 10 while retaining the original number if it is 10 or greater (i.e. 1=01, 10=10 and 300=300).
SELECT DISTINCT RIGHT('0'+CONVERT...
So I and two others are working on a time machine, and I accidentally press a wrong button and whoosh, all my friends and I are in 17th century Salem, Massachusetts.
Nobody sees us appearing out of thin air, so we aren’t burned to death on sight. But we are all wearing modern day clothes as we ...
I have a table which has multiple columns that have an ID, and I need to get information from one column wherever it matches.
tblA
colA | colB | colC | colD
1 5 6 7
2 5 5 8
3 7 8 9
4 8 8 9
Is there a way that I can Select column...
Conditions:
Budget of $40
Buy 2 distinct pizza from the same restaurant
Expected Results: List of restaurants that fulfill the above conditions
Database schema: Customers(cname, area), Restaurants(rname, area), Pizzas(pizza), Sells(rname,pizza,price), Likes(cname, pizza)
Sells table
| rnam...
Probably a newb question, but...
I have a table with a VARCHAR field containing numbers 1 through 300. I need to place a leading zero in front of any numbers less than 10 while retaining the original number if it is 10 or greater (i.e. 1=01, 10=10 and 300=300).
SELECT DISTINCT RIGHT('0'+CONVERT...
I have a table which has multiple columns that have an ID, and I need to get information from one column wherever it matches.
tblA
colA | colB | colC | colD
1 5 6 7
2 5 5 8
3 7 8 9
4 8 8 9
Is there a way that I can Select column...
Conditions:
Budget of $40
Buy 2 distinct pizza from the same restaurant
Expected Results: List of restaurants that fulfill the above conditions
Database schema: Customers(cname, area), Restaurants(rname, area), Pizzas(pizza), Sells(rname,pizza,price), Likes(cname, pizza)
Sells table
| rnam...
