Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Mantle51

  1. Mantle51

    Remove Decimal function

    OK, I didn't know you can concatenate functions like that. Thank you.......
  2. Mantle51

    Remove Decimal function

    Hello, I'm trying to write a function that will output 10 characters and remove the decimal. CREATE FUNCTION dbo.fnRemoveDecRate(@Rate VARCHAR(20)) RETURNS CHAR(10) AS BEGIN RETURN RIGHT(REPLICATE('0',10) + @Rate, 10) CASE CHARINDEX(@Rate,char(46),1) WHEN 0 THEN...
  3. Mantle51

    Chr() function equivalent for T-SQL

    Sorry 'bout that I found CHAR()--- not too difficult
  4. Mantle51

    Chr() function equivalent for T-SQL

    Hello, is there a T-SQL equivalent to VBA's Chr()? Thanks
  5. Mantle51

    UDF Error

    I'll try both ways.
  6. Mantle51

    UDF Error

    Yes that is exactly what I am trying to accomplish. Thank you so much bborissov!
  7. Mantle51

    UDF Error

    Hello, I'm attempting to convert VBA function into T-SQL but I keep getting error, "Return statements must include scalar valued arguments" CREATE FUNCTION dbo.fnPrefixZeroAC(@AC_Num varchar(20)) RETURNS varchar(20) AS BEGIN RETURN If Len(@AC_Num) > 7 fnPrefixZeroAC =...
  8. Mantle51

    Assinging UDT a value in .adp

    In that case I will declare a global variable in the .adp file. Thanks so much
  9. Mantle51

    Assinging UDT a value in .adp

    Hello, How would I go about assigning the value in a form in .adp project to a user defined data type in SQL server. I've already created the variable as EndDate and I'd like the following event to reflect in SQL Server... Private Sub Evaluation_ID_BeforeUpdate(Cancel As Integer) EndDate =...
  10. Mantle51

    View Code for System UDF

    Hello, After changing a UDF to a global function, that is, a system function on Master db, I can no longer see my code. This is obviously by design, but why and is there any way to view the code? Thank you.........
  11. Mantle51

    IF Statement in SELECT Query

    Esquared writes, "CASE is expressive, that is, evaluative. Queries are neither expressive nor procedural... call them operative" Is not the SQL syntax declarative by nature? So, is that the same as saying queries are operative? Also, is CASE then declarative(as being a subset of expressive for...
  12. Mantle51

    IF Statement in SELECT Query

    Implausable
  13. Mantle51

    IF Statement in SELECT Query

    That's reasonable[afro]
  14. Mantle51

    IF Statement in SELECT Query

    Hello, The following CASE statement works in this Select statement, however I was toiling unsuccessfully for quite some time to try to get an IF statement to accomplish the same thing. Is this not feasible? SELECT [Evaluation_Date],CASE WHEN [Period_Code] = 'D' THEN 'YES' ELSE 'NO' END AS...
  15. Mantle51

    Function List for SQL 2000

    Hi, I'm trying to create a select statement that determines if a single character in a field(the field is only one character) equals 'M'. I don't see IIF function available in SQL 2000 and I cannot use IF Then syntax in a SELECT statement. So how is this achieved without using a UDF? Many...
See more

Part and Inventory Search

Back
Top