Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azonicds2
Starting Member
4 Posts |
 Posted - 2014-04-01 : 05:25:13
|
| Hi Kinda new here and i cant for the life of me find an answer to this through google. This nay be a stupid question i appreciate that, but is it ok/possible to use and * in a column that is NVARCHAR type?ThanksDannny |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-04-01 : 05:37:51
|
where YourColumn like '%zonic%'
Too old to Rock'n'Roll too young to die. |
 |
|
|
azonicds2
Starting Member
4 Posts |
Posted - 2014-04-01 : 09:17:38
|
| Hi Sorry not quite sure what you are saying there?I have a columnd called "Description" and that column type is NVARCHAR. I'd like to know if i can put in for example "Mining Search*" as a record/row into that colunn or whether the "*" is unsupported with with NVARCHAR.Thanks in advance!Danny |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-04-01 : 09:31:44
|
yes. you can do that
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
azonicds2
Starting Member
4 Posts |
Posted - 2014-04-01 : 09:42:04
|
| Brill thanks Khtan! |
|
|
|
|
|
|
Asterisk in Nvarchar column type