Like Operator??

[gmatriix]

Hello All,

I trying to use a LIKE operator on a couple of fields. If the first field is Like the second field then return results. Obviously, I'm not writing this right.

(CharlesPart.PartName LIKE RoutingPeram.PartName)

Any Ideas?

Thanks

 

[Brianwarnock]

Ok so I have never used SQL Sever but I am sure that Like is for partial string matches and wild cards not a simple = which what you need, I take it this is part of an If or Where clause.

Brian

 

[gmatriix]

Yes it is part of a Where Clause

 

[David R]

http://technet.microsoft.com/en-us/library/aa933232(v=sql.80).aspx

 

[namliam]

Doing a like without a wildcard will make it act like an =
See the link provided by david for the wildcards