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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Asterisk in Nvarchar column type

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?

Thanks

Dannny

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.
Go to Top of Page

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
Go to Top of Page

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]

Go to Top of Page

azonicds2
Starting Member

4 Posts

Posted - 2014-04-01 : 09:42:04
Brill thanks Khtan!
Go to Top of Page
   

- Advertisement -