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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert/Remove RTF text info from SQL text field
Hi guys, (This is somewhat of a revamped version of a previous question I posted. I had mistaken the RTF formatting as something to do with Collation) I have a text field(notes) in SQL Server that is storing the data with all of the rtf formats. {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0...- nicoh99
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Pulling text into Excel from SQL text field with Collation
Hello, I have a text field(notes) in SQL Server that has the Collation set to <database default>. When I query the notes field I get the notes text along with the collation info. {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 MS Shell Dlg 2;}} \viewkind4\uc1\pard\lang1033\f0\fs17 test comments...- nicoh99
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Get a SELECT CASE range from an Excel cell
Hey guys, I am trying to pull a range from an Excel cell and plug it into a SELECT statement in my VBA code. For example, cell A1 has 33,34,35 in it. Sample Code: exampleNum = 34 Select Case exampleNum Case Range("A1").Value EXanswer = "Yes" Case Else...- nicoh99
- Thread
- Replies: 31
- Forum: VBA Visual Basic for Applications (Microsoft)
