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 |
|
SQLBoy14
Yak Posting Veteran
70 Posts |
 Posted - 2014-09-30 : 23:02:53
|
| Hello sql expert,I saw a case statement like below and I am wondering what the dbo.StudentID for?CASE WHEN StudentRegNum like '29%' THEN 'Not a Student' ELSE SUBSTRING(StudentRegNum,5,10) + dbo.StudentID(left (StudentRegNum,5), SUBSTRING(StudentRegNum,5,10))END)Thank youSQLBoy |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2014-10-01 : 01:17:49
|
| It is hard to tell without looking at schema, but most likely dbo.StudentID is a user-defined function.Harsh Athalyehttp://in.linkedin.com/in/harshathalye/ |
 |
|
|
SQLBoy14
Yak Posting Veteran
70 Posts |
Posted - 2014-10-01 : 23:59:22
|
| Thank you Hars_athalyeSQLBoy |
|
|
|
|
|
|
CASE with +DBO