title: sybase user defined function - "non deterministic" or "illegal built-in function" error
body: <p>When trying to create a user-defined functions (UDFs) on sybase 15+, you may get the following error:
  "illegal built-in function statement in scalar SQL function"
  This is b/c "non deterministic" functions such as getdate(), rand(), newid() are not allowed in UDFs.</p>
  
  <p>Is there a way around this limitation?</p>
  
  <p>Note that I plan answer my own question here.</p>