Click here to Skip to main content
15,398,432 members
Home / Discussions / Database
   

Database

 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:41
MemberHaidar ali24-Jan-15 7:41 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:42
MemberHaidar ali24-Jan-15 7:42 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 7:47
mveRichard MacCutchan24-Jan-15 7:47 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:55
MemberHaidar ali24-Jan-15 7:55 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 8:06
mveRichard MacCutchan24-Jan-15 8:06 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali25-Jan-15 0:04
MemberHaidar ali25-Jan-15 0:04 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan25-Jan-15 1:03
mveRichard MacCutchan25-Jan-15 1:03 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 19:14
Membernainakarri21-Jan-15 19:14 
Hi All

I am having sqlserver 2008R2 database, and in the table, there is a column "Text" with some string value.
Some of the strings are good (have the characters entered from keyboard" where some have values like "degree" symbol.

example:
SQL
Row 1 has string "Today temperature is 45Degrees C" where as Row 2 has string "Today temperature is 40°C


Row 2 has a symbol which is not entered through the keyboard. I want to filter such kind of symbols while querying.
Is there a way to query that way by filtering? If so, please provide me such query.

Thanks in advance,
Usha
Naina

AnswerRe: Need a Select query that filter illegal characters Pin
Eddy Vluggen22-Jan-15 0:28
professionalEddy Vluggen22-Jan-15 0:28 
AnswerRe: Need a Select query that filter illegal characters Pin
Umer Akram29-Jan-15 18:58
MemberUmer Akram29-Jan-15 18:58 
QuestionLet sql server code works for all SQLServer versions Pin
MrKBA19-Jan-15 23:10
MemberMrKBA19-Jan-15 23:10 
AnswerRe: Let sql server code works for all SQLServer versions Pin
Eddy Vluggen22-Jan-15 0:26
professionalEddy Vluggen22-Jan-15 0:26 
Questionchanging the field of database based on changes in repeater Pin
Armi.R16-Jan-15 21:21
MemberArmi.R16-Jan-15 21:21 
AnswerRe: changing the field of database based on changes in repeater Pin
Mycroft Holmes19-Jan-15 23:57
professionalMycroft Holmes19-Jan-15 23:57 
QuestionDB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 2:59
Membersudevsu16-Jan-15 2:59 
QuestionRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:10
professionalGuyThiebaut16-Jan-15 3:10 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:22
Membersudevsu16-Jan-15 3:22 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:46
professionalGuyThiebaut16-Jan-15 3:46 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:55
Membersudevsu16-Jan-15 3:55 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:21
Membersudevsu16-Jan-15 3:21 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:59
professionalGuyThiebaut16-Jan-15 3:59 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:30
Membersudevsu16-Jan-15 4:30 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:41
professionalGuyThiebaut16-Jan-15 4:41 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:43
Membersudevsu16-Jan-15 4:43 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:48
professionalGuyThiebaut16-Jan-15 4:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.